We recently purchased a third party tool to run in side by side with our SQL based product. In strategizing the best way to deliver this product to our existing base, we deemed having templates be provided that map the tables in Excel would be the easier procedure to proceed with.
One limitation I'm running into is the Insert statement I typically use with other Excel to SQL imports:
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$]')
Using this statement requires that I have all of the columns in Excel in the same order as the tables I am inserting into. Is there an easy way to tie the SQL column titles to the column titles I'd use in Excel so that I can move the columns in Excel around to make my Excel workflow easier for data entry versus the way that the programmer has the SQL tables aligned?