469,282 Members | 1,624 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,282 developers. It's quick & easy.

Import data from excel sheet to ms sql server table

1
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. :)
Sep 1 '06 #1
2 16374
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
Sep 1 '06 #2
ramasp
19
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.
Sep 4 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Sreedhar Vankayala | last post: by
10 posts views Thread by Niklas | last post: by
2 posts views Thread by madeleine | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.