CSV to access with vba

[RobDog888]

You can use the .TransferSpreadsheet method inside of Access to Import the sheet in one line of code.

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Table1", "C:\Test.xls", False

[salvelinus]

I don't think that'll work for him, from his example. No common delimiters, for one thing. It looks like he'll have to read it in and parse the string somehow.