[KLUG Members] Re: Database import help

[John Holland]

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