Error Importing Fixed-Width Text File

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?
 

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

Importing Fixed Length File into Access 2007 1
Import Fixed Width (.dat) file 7
import csv conversion & import spec error 1
Import Specs Changed "Magically" in Midst of Loading Sequence 3
Edit Import Spec (A2007) 1
Type Conversion Failure importing number as text 1
Import Text File with Import Spec 3
Dropped record on automated transfer text 1

Top