[dba-SQLServer]Importing txt file

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