Text import problem

[Netherby]

I need to import data from a text file into Access but the problem I have is that the application that generates the text file saves it with a .res extension.

The code I'm using is DoCmd.TransferText acImport, , "tbl_import", "C:\zzz1.res" but I get an error message saying 'You cannot import this file'

Any help would be appreciated. Is there a way to change the .res extension to .txt using VBA?

Thanks

 

[oharab]

To make Access more secure (though god only knows how!), it will only let you import text files with a fixed set of file extensions.
You can either alter the registry key that lists the allowed extensions, or change the file name.

http://support.microsoft.com/kb/306144

gives you instructions for both methods.

hth

Ben

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

We could be confused in exactly the same way, but confusion might be like Nulls, and not comparable.

 

[Ed2020]

You can download a registry patch for this issue from here:

http://solihullpcdoctor.pwp.blueyonder.co.uk/downloads.html

(

http://solihullpcdoctor.pwp.blueyonder.co.uk/freeware/MS Access File Extensions.zip)

Ed Metcalfe.

Please do not feed the trolls.....

 

[Netherby]

Thanks all.

I've just managed to overcome the problem using FileCopy as follows:

FileCopy SourceFile, DestinationFile

SourceFile is my original .res file and DestinationFile is a new file with a .txt extension.

 

[Ed2020]

Alternatively you could use:

    Name <filepath here> As left(<filepath here>,len(<filepath here>)-3) & ".txt"

Ed Metcalfe.

Please do not feed the trolls.....