G
Guest
I want to import a fixed-width text file using VBA. I set up an import spec.
When I import the file manually (File >> Get External Data >> Import
....), the file imports properly.
When I use a macro (with the import spec), the data in each record gets
dumped into the first field of the record.
When I use VBA (with the import spec), I get an Error 31519: You cannot
import this file.
Any suggestions?
When I import the file manually (File >> Get External Data >> Import
....), the file imports properly.
When I use a macro (with the import spec), the data in each record gets
dumped into the first field of the record.
When I use VBA (with the import spec), I get an Error 31519: You cannot
import this file.
Any suggestions?