Importing Spreadsheet

[derfalpha]

I was wondering if someone could point me to the right direction.

Let's say I have a table like so:

CUSTOMER(ID, Name, Telephone, Business Name)

I would like to import about 50k rows from a spreadsheet into this table, but the spreadsheet is formatted like so:



Name, ID, Business Name, RandomAttribute1, RandomAttribute2, Telephone

Is there a way to import this data without having to the fiddle (move and delete) columns from the spreadsheet?

[NTC]

sure; import the spreadsheet 'as is' into any temp table. then do an append query of this table to the final table.

hope this helps.