I have to write an import to SQL2000 from Excel. The import will be run
multiple times a day and from different excel files to different databases.
The import will have to be run from a user end(Tech Support). I was
beginning to write it in DTS but I was wondering if there is a better tool
or if there are some tips on how to get the user to input the database and
the excel file with out having to get into the dts package?
Basically it looks like this now
1. Create 2 tables in temp db
2. Import from excel to temp tables
3. Update/clean temp table data
4. Copy to Live table
5. Delete tables in Temp db