J Jamilu Abubakar [MSFT] Jul 22, 2003 #2 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
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
