Importing delim file saved as .xls

  • Thread starter Thread starter compsteve
  • Start date Start date
C

compsteve

I'm trying to use VBA to automate the import of a file that has the extension
of .xls but is in fact a delimited file. When I open excel and try to open
the file the text import wizard opens. I have tried to do a transfertext
method but it gives a runtime error 31519. ANy suggestions would be greatly
appreciated.
 
compsteve said:
I'm trying to use VBA to automate the import of a file that has the
extension
of .xls but is in fact a delimited file. When I open excel and try to
open
the file the text import wizard opens. I have tried to do a transfertext
method but it gives a runtime error 31519. ANy suggestions would be
greatly
appreciated.
Click to expand...

You need to rename the file (or make a copy of it) with the extension .txt
or .csv

You can do this manually, or if you need it automated, try this (air code) :

FileCopy "MyPath\MyFile.xls", "MyPath\MyFile.txt"
DoCmd.TransferText acImportDelim, "MySpec", "MyTable", "MyPath\MyFile.txt"
 
Back
Top