[AccessD] Importing Text File

Hi David

If your file has another extension than txt that could be the cause.

I would recommend running my own import routine, then you are in
control. This has been discussed many times - look up the archive.

/gustav


> Access XP ade, SQL2000

> I am transferring a text file into an SQL BE for processing.  The command I 
> am using is -

> DoCmd.TransferText acImportDelim, , "dbo.ttmpTOURawData", strFullName, False

> It works fine on my development machine.  When I take it to my client's 
> site and run the code from a run time installation (using Sagekey/Wise 
> installation) I get an error message Error 31519 - You cannot import this file.