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.
 
Back
Top