Users don't have SQL Enterprise Manager and need to keep information on the SQL server up-to-date. Their data is in MS Excel format. They would like to upload the data from the MS Excel to SQL database. This means, INSERT, UPDATE, and DELETE entries in SQL by using data from the MS Excel file(in CSV format). Can you help?
You can dynamically run a DTS, and it will parse the files for you. Or you can do it manually.<BR><BR>I'd go the DTS route if the data typically doesn't change format. Basically they can upload the spreadsheet, and you can fire the DTS to go and parse these files.