imporing a csv

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking at importing a csv instead of an xls spreadsheet. The following
line;

DoCmd.TransferSpreadsheet acLink, 8, Me.txtOldName & "NewQ", File, True, ""

has an error message return that it is not in the proper format, which I
realize. But, the import file will always be a csv. What should be used
instead?
Thanks ... John
 
Use TransferText.

Although you may see CSV files handled by Excel, they are actually text
files.
 
Back
Top