Reputation: 85
I am looking for a script or ideas on how to Quickly and efficiently import data from Excel 2007 Into a temp table in SQL Server Mangement Studio 2008? (I have win xp)
I have a table in an Excel file (XLtest.xlsx) that contains two Column (Column X) and (Column Y) in sheet (shTest).
Want to import excel table to my database (test) in SQL as a temp table (temp table).
Find the table (Mobi) in the database (test) and Column (Column X2)
Replace the values in (Column X2) with values from (Column Y) when the values of (Column X2) equal to the values of (Column X).
Wishing all a happy new year. Thanks in advance
Upvotes: 1
Views: 283
Reputation:
Your tasks will be best and easiest accomplished with a SQL Server Integration Services (SSIS) package. You can learn more about SSIS here: http://msdn.microsoft.com/en-us/library/ms141026.aspx
Upvotes: 1