[KLUG Members] Re: Database import help

[Andy]

Ok.. not to sound to dumb .. ( though I will profess
my ignorance when it comes to SQL statements) 

I understand the Joining of tables.. but I have no
reference to the crosswalking of data you are speaking
of.. I have about 3 different references (though most
are on administering the database and only 1 is on
actual query structure) So I assume you are saying
that I could setup a Query that will Insert all the
data from Temptable to Live table except for the field
that needs to change? Or would I do the insert and
then have to run an Update on those rows that I just
inserted to do correct that field? 

Could you point me to a good Transact-SQL reference
that may help me in my search (I would rather learn
than ask for an out right answer). 


--- John Holland <john@zoner.org> wrote:
> I would import the text file into a temporary table.
>  Then you can
> join tables to crosswalk from the student ID to the
> internal linking
> number.
> 
> On Thu, Feb 27, 2003 at 12:14:04PM -0800, Andy
> wrote:
> > 
> > I have a text file that has Student Test Scores in
> it
> > and I need to Import them into a SQL Database. The
> > problem is the text file is a comma delimited file
> in
> > a different format than the table the information
> > needs to be imported to. Also the primary key is
> > different as well (file has the student ID and the
> > table has an internal linking number not the ID). 
> 
> --
> John Holland 
> john@zoner.org
> http://www.zoner.org
> _______________________________________________
> Members mailing list
> Members@kalamazoolinux.org
>



__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/