Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Automatically Importing multiple .csv files into db table
Many thanks, now works a treat..- n4nz
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Automatically Importing multiple .csv files into db table
Ok here's the code i'm trying to use, however when run the Dir picks up the file name no problem, but then i get an Jet database Engine error telling me that it can't find the object 1.csv (which happens to be the file) Function ImportCSV() Dim ImportFile ImportFile = Dir("d:\test\*.csv") Do...- n4nz
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Automatically Importing multiple .csv files into db table
Hi guys, I am trying to import multiple .csv files into one table using DoCmd.TransferText acImportDelim, I have no problems with one csv file but I want it to loop so that the contents of a directory specified containing all .csv files are imported or appended. Thanks in advance- n4nz
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
