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