I know I've read this somewhere, but I can't seem to find it.
I need to be able to import specific non-contiguous Excel columns into specific non-contiguous SQL table columns. For example, import data from Excel columns A, B, J, and T into SQL table columns 1, 4, 5, and 12.
What's the best way to do this?
I'm using SQL Server 2000, with an Access2000 front-end.