Import Excel or CSV File Using TransferSpreadsheet or TransferText

  • Thread starter Thread starter kemosabe
  • Start date Start date
K

kemosabe

I am downloading a file from an SQL server. I've tried saving it as CSV and
CSV for MS Excel. Regardless of how I format the downloaded file, I cannot
get Access macro function TransferSpreadsheet or TransferText to work. I get
the message that the file cannot be found (based on path I've given, which
I've confirmed multiple times) or cannot import a text file without
extensions TXT, CSV, etc. I've tried adding the extension to the file name
and it still doesn't work. Any ideas what I'm doing wrong?
 
Save it as an EXCEL file (.xls) and then ACCESS should be able to import it
via TransferSpreadsheet.
 
Back
Top