471,595 Members | 1,601 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,595 software developers and data experts.

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 16478
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 XIAOLAOHU | last post: by
reply views Thread by Anwar ali | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.