Importing flat text file with "other" extension

  • Thread starter Thread starter jdsf
  • Start date Start date
J

jdsf

I'm trying to import a flat text file into Access but the
data source has a file extension other
than .txt, .csv, .tab, and .asc. Is there a way to edit
the "Files of type" so it will recognize a different
extension?
 
-----Original Message-----
I'm trying to import a flat text file into Access but the
data source has a file extension other
than .txt, .csv, .tab, and .asc. Is there a way to edit
the "Files of type" so it will recognize a different
extension?
.
JDSF,
Click to expand...

Yes, there is away to change the Flat file to a TXT file.
Just load the Flat File in to Notepad and select the save
as function, and then save the flat file to a txt file.

I hope that works.

Ted
 
Here are two different approaches.

This http://support.microsoft.com/default.aspx?scid=kb;en-us;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>).

This http://support.microsoft.com/default.aspx?scid=kb;EN-GB;306144
includes code that automatically makes a copy of the textfile with a
..txt extension and imports that.

I'm trying to import a flat text file into Access but the
data source has a file extension other
than .txt, .csv, .tab, and .asc. Is there a way to edit
the "Files of type" so it will recognize a different
extension?
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Back
Top