[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