Can do DoCmd.TransferSpreadSheet work for a csv file?

[mp3909]

I have a csv file.



I want to transfer the data in this file into a new table in Access.

I currently have this code in VBA:

Public Sub ImportExcelSpreadSheet(fileName As String, tableName As String)
    DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, tableName, fileName, True
End Sub

filename is "C:\Temp\xyz.csv"
tablename is "xyz"


but I get an error saying "External table is not in the expected format"

[isladogs]

A CSV file is just a text file with a specific structure
Use TransferText instead

[mp3909]

Yes, it was the DoCmd.TransferText method I needed

But, my table does not have the column headings from the csv file.
Instead, it is just showing as "Field1, Field2,,,,,,,,,,,,,,Field37"
I did specify "True" for "had headings" in the DoCmd.TransferText

[isladogs]

This syntax works & imports first row as field names

DoCmd.TransferText acImportDelim, , "TableName", "FullFileName&Path.csv", True

[CJ_London]

perhaps your .csv file has a blank line at the top?