I have one excel worksheet. I like to export the data into sql server table. Pls explain.?

Question

I have one excel worksheet. I like to export the data into sql server table. Pls explain.?

Answer 1

you can use Data Transformation Services in SQL Server Enterprise Manager.

You create a new DTS Package, then when the DTS Designer opens, you create a source connection to the Excel file with the data in it, then you choose the destination table as another connection.

You can get lot's of help with this on the links I have included below.



Hope that helps

Answer 2

u can use the SQL server Enterprise manager to import the excel worksheet into the sql server table.

if u have not defined the table structure so far that will be automatically created on importing the excel file.

if u have created the table structure while importing you will have to take care of null values or null attributes and unique/primary keys.

also while importing the file the file should not be in use by any other application.

you can only import the excel file into the SQL table if u can map the schemas of both the objects.

Answer 3

You probably want to go through SQL Server, and import the excel file into it, but this step should be done with much care because if the excel sheet is not organized as it should be, the data in the database will be more like rabish!!!



Enjoy ;)

Answer 4

just use data adapters to do ur job or u can create a dsn for it