Excel Csv files

[marko23]

Hello Guys,

Im really hoping someone can help me,

I have a load of Excel csv files that Im trying too import into Access, I just wondered if anyone knows a macro or a VBA automation way of importing multiple csv files into access?

You would really appreciate someones help on this

Thanks

Markus

 

[GhostWolf]

The best luck I've had with this is using a Schema.ini file that looks something like:

[Sales.txt]
ColNameHeader=FALSE
CharacterSet=OEM
Format=CSV
Col1=ProdPart Char 
Col2=UsedPart Char 
Col3=UsedPct Char 
Col4=Decimals Char 
Col5=RtvDate Char

If all your files are in the same folder, and they're all going into the same target table, you could use the File System Object and loop through the files, executing something like:

    wrkName = "Sales.txt"
    cmdUpdate = "insert into SalesImport select * from [Text;database="
    cmdUpdate = cmdUpdate + ProjectPath + "]." + wrkName
    dbQuery.Execute cmdUpdate, dbFailOnError

NOTE: the program variable ProjectPath does not have a trailing back-slash.

HTH