How to import a csv file into access

[zebra1057]

Hello,

I hope somebody can help.

I have a csv data(separated by commas) saved as .txt file.
How can I import it to MS Access without retyping the whole data?

Thank you in advance for any clue.

zebra1057

 

[fneily]

First, post Access questions in the Access forums - you'll get a larger response.

Open your database. Click on File, Get External Data, Import, change Files of Type to Text Files. Select your file and follow the wizard. It's quite easy.

After it's imported, NORMALIZE. If you don't, you're not using Access correctly.