Jayded (4/15/2010)

---

INSERT INTO MAPPINGTABLE
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\Documents and Settings\user\My Documents\Length Adjustments\Mapping\Mapping Table.xls', 'SELECT * FROM [Sheet1$]')

INSERT INTO MAPPINGTABLE (Col1, Col2, Col3)
SELECT Col1, Col2, Col3 
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\Documents and Settings\user\My Documents\Length 
Adjustments\Mapping\Mapping Table.xls', 'SELECT * FROM [Sheet1$]')

Jayded (4/15/2010)

---

Thanks Wayne! In this instance when I'm making the lists do I have to have a consistency that SQL column 2 points to Excel column 3 such that if someone were to re-sort the Excel spreadsheet and move that column to column 4 that it would no longer work?

Would there be a way to tie the two via the column ID in SQL?

Ex. Column sCodeID in SQL is currently in Excel column 2 and row 1 is labled as sCodeID but should someone move that to column 8 it would still be ok as the system realizes that the column headed sCodeID belongs with SQL sCodeID regardless of where it is.