Table Linker (v2000)

Topic

New Reply

I have a batch of *.CSV files that are loaded to a folder each month. I want to import the contents of these files one by one into an existing table using code. The problem is I don’t know the naming convention…only that they will be in the folder and will contain a *.CSV extension. How can I get VBA to find the first *.CSV file, import it and move to the next file until all CSV files have been imported?
Thanks,
Dashiell

Reply | Quote

Replies

Dim strMatch as String
strMatch = Dir(“yourpath*.csv”)
Do While strMatch “”
DoCmd.Transfer ……………………..
Dir
Loop

Reply | Quote

Dim strMatch as String
strMatch = Dir(“yourpath*.csv”)
Do While strMatch “”
DoCmd.Transfer ……………………..
Dir
Loop

Reply | Quote