Exporting to either a .csv or directly to Access

[BrianB]

New to the forums here and I have a question. I did some searching
through these forums but could not find the exact answer I was looking
for.

I have a custom form that my company uses to send new vehicle
information between departments (we are a leasing company). What I
ultimately need to do is take the information from the form and input
it into Access. I would like to do this directly but I cannot use any
3rd party software (as was suggested in other posts) and my VB
scripting knowledge is limited.

If the above is not possible, I have created a field that combines the
data from all of the user defined fields into one concatenated field.
I could just export that data into a .csv file and then set a macro in
Access to import the data. What I need to know is there some way to
create a button on the form that will do the exporting without having
to cut and paste. This will be for a couple of end users that do not
have a lot of PC experience.

Any help would be much appreciated.

Thanks in advance,
Brian

 

[Sue Mosher [MVP]]

You would need to write code behind the button to create the file and
populate it with data from the the custom Outlook items. See
http://www.slipstick.com/dev/customimport.htm for links to samples and other
resources.