imporing a csv

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
 
A

Allen Browne

Use TransferText.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TransferSpreadsheet Link method with .csv problem 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Problem with access acImportDelim importing csv with headers 1
send reminder email through outlook based on info from a csv/excel file 0
csv Import into Access db 2
Access Importing csv daily files into access 2007 1
Excel And Notepad 3
CSV Import Error 2

Top