[KLUG Members] Database import help

[Andy]

Not sure if this can be done programmatically or not
but here goes the question...

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). 

So not knowing any programming (currently) is there a
way of looking at a seperate table in the database to
get the internal link field to come over and then
create a new txt file or table in the database that
has the new internal link number and the tests scores
so that I can then import into the proper table.

I can always retype the text file... but that will be
a pain for 5000 records.

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