Import .DAT file

[Mike Labosh]

Is there any way to beat Access 2000 into submission so that I can import
tab-delimited ASCII files that have a .dat extension instead of .txt and
..csv?

--
Peace & happy computing,

Mike Labosh, MCSD

"Mr. McKittrick, after very careful consideration, I have
come to the conclusion that this new system SUCKS!"
~~ General Barringer ~~

 

[Dirk Goldgar]

Is there any way to beat Access 2000 into submission so that I can
import tab-delimited ASCII files that have a .dat extension instead
of .txt and .csv?

Maybe this has your answer:

http://support.microsoft.com/default.aspx?scid=kb;en-us;306144
ACC2000: How to Import a Text File That Has an Extension That Access
Does Not Recognize

 

[Andi Mayer]

Is there any way to beat Access 2000 into submission so that I can import
tab-delimited ASCII files that have a .dat extension instead of .txt and
.csv?

if you want full control you could use:

look at the help file for
Line Input # Statement Example