[dba-SQLServer]Importing txt file

I don't think it is a problem with references by that Transfertext doesn't 
work with SQL Tables.  Is there anyone else using an ADP and can use 
TransferText?

David


At 27/02/2003, you wrote:
>Hi Doug:
>
>Check you references. There is probably a specific ole or dll that Access97
>had installed through it's reference list that is not installed by default.
>Check the items in the Reference list in Access97 and then check
>Access2002's Reference list. Install the missing entry(s) and it should run
>fine.
>
>HTH
>Jim
>
>-----Original Message-----
>From: dba-sqlserver-admin at databaseadvisors.com
>[mailto:dba-sqlserver-admin at databaseadvisors.com]On Behalf Of David
>Emerson
>Sent: Thursday, February 27, 2003 5:41 PM
>To: dba-SQLServer at databaseadvisors.com
>Subject: [dba-SQLServer]Importing txt file
>
>
>In my A97 database I have a line which imports some raw data into a
>temporary table -
>
>DoCmd.TransferText acImportDelim, "CVRAW", "ttmpCVRaw", C\Data\RawData.txt,
>True
>
>Now that I have an AXP connected to SQL2K this doesn't work.  What is the
>method for importing into a table?  From here I will be using a sproc to
>manipulate the data into the right format to be added to another table.
>
>
>Regards
>
>David Emerson
>DALYN Software Ltd
>25b Cunliffe St, Johnsonville
>Wellington, New Zealand
>Ph/Fax (877) 456-1205
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com