[AccessD] Importing Text File

David Emerson davide at dalyn.co.nz
Tue Jun 1 13:56:16 CDT 2004


Thanks for the response.

The client is logging in using their own username/password as set up in 
SQL.  I have checked the permissions on the table and they are ok.

Is it possible that a dll needs to be registered to be able to import text?

David

At 31/05/2004, you wrote:
>David:
>
>How do you log on to you local server?
>(username/password/servername/databasename) You may not have logged in to
>your client's server properly or have access rights. If they are using
>pass-through or server validation make sure your username and password has
>been added to the security list or attached user group and your security is
>high enough. Finally, make sure, as a user, you actually have write rights
>to the tables and executable rights to any SPs.
>
>HTH
>Jim
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of David Emerson
>Sent: Monday, May 31, 2004 10:26 PM
>To: accessd at databaseadvisors.com
>Subject: [AccessD] Importing Text File
>
>
>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.
>
>The destination table exists on the client's server.
>
>I cannot find anything on the web or help or BOL.  Is there a file that
>should be included in the installation to allow importing?  I can export
>text files from within the program ok.
>
>
>Regards
>
>David Emerson
>Dalyn Software Ltd
>25 Cunliffe St, Churton Park
>Wellington, New Zealand
>Ph/Fax (04) 478-7456
>Mobile 027-280-9348
>
>--
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>--
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com




More information about the AccessD mailing list