Import data from excel sheet to ms sql server table

How to import data from excel sheet to ms sql table the data in the excel is the one which is exported from oracle, few data fields of the ms sql server are of int type and few are of varchar, how can I Import data into sql server 2000 with out getting any errors?

It would be helpful if any one can reply (step wise). Thanks in advance. :)

Quote:

Originally Posted by Purvi

How to import data from excel sheet to ms sql table the data in the excel is the one which is exported from oracle, few data fields of the ms sql server are of int type and few are of varchar, how can I Import data into sql server 2000 with out getting any errors?

It would be helpful if any one can reply (step wise). Thanks in advance. :)

What errors are you recving?? You could format the xls sheet to be text, then convert it to whatever you need in MSSQL using DTS. Hope that helps|||The following are the steps to be followd.

1.copy the data from the existing excel sheet to a new excel sheet and save it.
2. Use DTS service and transfer data to a sql server table. For example the table is created with name like sheet1$. Just rename it and change the datatypes of columns in the design mode as you like.
3.when ever you change data from excel to a table, if you get error simple follow the 1 step.