Transfer Excel Data

  • Thread starter Thread starter cfyam
  • Start date Start date
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying from SQL Server database to Access and Vice versa 0
News USB4 announced, will double data transfer speed 3
How to Transfer Emails from One Gmail Account to Another? Simple Steps 3
RichTextBox formatation transter 3
Transferring Data from SQL Server to Excel using .Net 1
Excel Move or Copy Stopped Working? 0
How to transfer the data from userform to spreadsheet for specific dates 0
Access Access database invalid syntax error message 0

Back
Top