How to move data from an .XLS file into a SQL Server table?

  • Thread starter Thread starter Steve Kershaw
  • Start date Start date
S

Steve Kershaw

Hello,

I need to move an Excell (.xls) table into a SQL Server 2005 table. How
can I do this?

thanks

Steve
 
You have to use SQL Server Business Intelligence Development Studio and
Create a new Integration Services Project. Then used the Bulk Insert
Control and import the Excel File to the table that you want.
 
You must log in or register to reply here.

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

Insert or Save file into SQL Server Database Table with C# Examplesand VB.Net Examples 0
What are the steps to fix damaged MDF files in SQL Server? 0
How to generate excel files at asp.net server side 3
Beginning .Net : Insert data into SQL Server Database with C#Examples and VB.Net Examples 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
How to change default sql server? 4
Excel Moving data to sheet2 from sheet1 0
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top