DoCmd.TransferSpreadsheet

[M_S_Jones]

Hi,

I'm trying to import a CSV file into access using the DoCmd.TransferSpreadsheet action. I've managed to get a workbook version of the CSV file to import by saving the CSV file as an Xls file and then running the VBA code with the 'spreadsheet type' parameter blank (to run the default). This works fine, so now I would like to import the CSV version of the file. Can anybody tell me what the 'spreadsheet type' value should be to import a CSV file?

Thanks,

Matt

 

[M_S_Jones]

Just in case anybody else faces this same problem, I managed to eventually solve this issue by using the TransferText action, rather than the TransferSpreadsheet action.