[dba-SQLServer]Importing txt file - Solved

It seems that ADP's don't have specs for importing.  I needed to rename the 
fields in the column header of the txt file to match the fields in my SQL 
table.  Then the transfertext command worked ok.

(Sorry about the confusion Susan - By temporary table I meant one I had 
created in SQL as a temporary store of the data so that I could tidy it up 
before using it in my main tables).

David

At 3/03/2003, you wrote:
>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
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com

Regards

David Emerson
DALYN Software Ltd
25b Cunliffe St, Johnsonville
Wellington, New Zealand
Ph/Fax (877) 456-1205