regularly importing from csv

[Grip]

I'm getting a .csv file that I need to import into my Access db. The
file contains info for about 60 fields spread across 10 related
tables. I've got between 2 and 20 rows in my csv file that I want to
import on a weekly basis. What is the best way to accomplish this?

Thanks,
G

 

[John W. Vinson]

I'm getting a .csv file that I need to import into my Access db. The
file contains info for about 60 fields spread across 10 related
tables. I've got between 2 and 20 rows in my csv file that I want to
import on a weekly basis. What is the best way to accomplish this?

Thanks,
G

Probably link to (rather than import!) the csv file and run a series of Append
queries to migrate the data into your normalized tables. The queries can be
run from a Macro or (better) from VBA code.