Import .dat file doesn't work

  • Thread starter Thread starter Chuck
  • Start date Start date
C

Chuck

My macro runs Transfertext action that is set to copy data
from a Fixed Width .dat file, using a Specification, to a
table in my database.
The macro runs cleanly, but no data is transfered to the
table.
What would cause this?
 
Normally one would get an error message giving some indication of the
problem: have you used the SetWarnings action to suppress them?

One possible cause is the .dat file extension. Do things work OK if you
rename the file to .txt ? If so, see ACC2000: How to Import a Text File
That Has an Extension That Access Does Not Recognize (306144)
http://support.microsoft.com/?id=306144




My macro runs Transfertext action that is set to copy data
from a Fixed Width .dat file, using a Specification, to a
table in my database.
The macro runs cleanly, but no data is transfered to the
table.
What would cause this?
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 

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

Dat File 2
Import Fixed Width (.dat) file 7
importing .dat files 2
import data 1
Export/Import .dat file extension 2
Import from notepad Pipe delimited text document 1
Appending to an Exported Fixed Width File in Access 2
The text file specification '4' does not exist 0

Back
Top