import csv files to access db

[jnewl]

have multiple csv files in a folder that i want to import to access. the
table name in access would be the name of the csv file.

not sure how to code the tblnames in the docmd.transfertext command and also
to set up wild card function to extract the individual csv files

thanks for your help

 

[Tom van Stiphout]

On Thu, 30 Oct 2008 15:56:00 -0700, jnewl

To loop over the files in some folder use the Dir function. See the
help file for the details. Then you have a variable that holds the
filename of the current file. You can strip off the ".csv" part using
a combination of Left$ and Len, and then use that in the TransferText
call.

-Tom.
Microsoft Access MVP

 

[papazar]

have multiple csv files in a folder that i want to import to access. the
table name in access would be the name of the csv file.

not sure how to code the tblnames in the docmd.transfertext command and
also
to set up wild card function to extract the individual csv files

thanks for your help