Can Access Import CSV?

[DeanRowe]

Hi,
I'm using Access 2000.

I use a feedback form on my website to receive my customer details by email.
Currently I print out the data and type it into my form.

I can alter my feedback form so the data in the email is seperated by comma's.

Is there anyway I could import the comma seperated values directly into my database rather than typing each one in by hand?

Or could anyone recommend a different method of transferring the data from the email please?

Any help would be greatly appreciated!

Many, many, many thanks!

 

[boblarson]

Yes you can, if you go to File > Get External Data > Import you can follow the wizard to import text files (or other files for that matter).

To do it in code, look into the DoCmd.TransferText command.