Import .dat file doesn't work

[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?

 

[John Nurick]

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?

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.