adding to these extentions:txt,csv,tab,asc,htm,html.

[Guest]

When I try to import a text file with an extention .dat I get an error You
cannot import a text file unless it has one of these
extentions:txt,csv,tab,asc,htm,html. How ca I add the .dat or files with
other extentions to the list of acceptable file extentions?

 

[Guest]

You can't. You have two choices:
1. Rename the file with an acceptable extension. This, of course,
presupposes the format of the file can be understood by Access.
2. Using VBA, open the file, read it line by line, decompose the lines into
fields, and put the data where ever it needs to be.

 

[Ken Snell [MVP]]

This MS Knowledge Base article presents information about this:
http://support.microsoft.com/?id=306144

 

[John Nurick]

This http://support.microsoft.com/?id=304206 shows how to change the
extensions that Access will accept. The neatest method is the last,
editing the registry (provided you're careful<g>).

Alternatively, this http://support.microsoft.com/?id=306144 includes
code that automatically makes a copy of the textfile with a .txt
extension and imports that.