I want to import varying excel spreadsheets into a sql server 2000 database
using the DTS import wizard. The excel spreadsheets are in various formats,
differing columns all the time, and the column sizes change all the time.
I want to be able to import data from the excel spreadsheet into the sql
server 2000 database without having to define the exact columns in sql server
2000 first. Thus, how can I importing the excel spreadsheet into the sql
server 2000 database without having to define the columns in the sql server
2000 database first?
I would like this process to happen almost automatically.