Importing a text file with a .01 extension

[DropsIT]

I am trying to import a file to a table but the file has an extension of .01. Access won't import the file unless I change the extension to .txt first. Can I force it to import the .01 extension file as I need to avaoid any manual renaming prior to the import ?

 

[PHV]

If you can't rename the file why not simply import a copy of it ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[CautionMP]

DropsIT,
You can add [tt].01[/tt] to the registry as a valid text file format. This will have to be done on any machine that needs to import the file. IMHO it's easier (safer?) to manipulate the file extension then import as normal.

If you want to add the extension try searching for:

[tt]HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Text\Extensions [/tt]

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)