January 30, 2006 at 7:53 am
The end user put the report (excel ) in the one folder in the network. Every week I plan to look up what new data input from the excel file and append to my master employee table. How can I achieve that in SQL Server 2000 ? thanks.
January 30, 2006 at 8:17 am
Without knowing the exact DDL of the user table and what data resides in the Excel sheet it's dificult to give a detailed answer. However, the general process could be done be either using the excel sheet as a data source defined in a DTS package and then transformed into the table using a query to define the transformation. Or, you could import the excel sheet into a loading table and then perform the required updates and deletes from there.
January 30, 2006 at 8:27 am
Thanks. basically I need to match SS from the excel to the employee master table. if no find, then append them, I want to auto the process.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply