[dba-SQLServer]Importing txt file

If you are using an ADP, there is no such thing as a temporary table in
the Access FE file.  You'll have to do it all in SQL Server.  There are
temp tables in SQL Server denoted by a # before the name; and you'd use
DTS to get the data into SQL Server.

--Susan

-----Original Message-----
From: David Emerson [mailto:davide at dalyn.co.nz] 
Sent: Friday, February 28, 2003 1:43 PM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [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

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com