C
cfyam
How can I transfer Excel data to Sql Server?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jamilu Abubakar [MSFT]
Hi,
If the data that you have in Excel is the form of regularly structured
tables then the best way to get your data into Microsoft SQL Server is to
automate a Data Transformation Services package.
There is a support webcast on how to do this on:
http://support.microsoft.com/default.aspx?scid=/servicedesks/webcasts/
wcd111802%2Fwcdblurb111802.asp
The article "HOW TO: Handle Data Transformation Services Package Events in
Visual C# .NET" on http://support.microsoft.com/?kbid=319985 may also be of
use.
If you are new to Data Transformation Services refer to the SQL Server
Books On-Line that ships with SQL Server.
I hope this information is useful.
Kind regards,
Jamilu Abubakar [MSFT]
Microsoft
If the data that you have in Excel is the form of regularly structured
tables then the best way to get your data into Microsoft SQL Server is to
automate a Data Transformation Services package.
There is a support webcast on how to do this on:
http://support.microsoft.com/default.aspx?scid=/servicedesks/webcasts/
wcd111802%2Fwcdblurb111802.asp
The article "HOW TO: Handle Data Transformation Services Package Events in
Visual C# .NET" on http://support.microsoft.com/?kbid=319985 may also be of
use.
If you are new to Data Transformation Services refer to the SQL Server
Books On-Line that ships with SQL Server.
I hope this information is useful.
Kind regards,
Jamilu Abubakar [MSFT]
Microsoft