How do I import .cvs data to access.

[freedomyou]

I used paypal (.csv) and want to import the data to access. What is the best way to do this? I am going to build a new data base to do this as the present one has a one to many relationship. The .csv text has "fdfdf"

 

[dugbel]

You can set up the csv as a linked Table or you can create a Schema.ini and link to it on the fly and pull the data in.

There are quite a few articles in the MS Knowledge Base on Schema.ini files.

 

[freedomyou]

Hi dugbel,
I have never even heard of Schema.ini Is it part of access. Also, when I create a linked table and add more records to the CSV document it does not update the info into access.

 

[Pipewelder]

Are you changing the name of the CSV file when you edit it from another program?