You can import the excel without any error if the columns of the excel and the column in database table are same.
one of the thing came in to mind with your question is that may be in your excel some of the coluns values are missing (means the column which are not null in database table, you are passing as null values from the excel) make sure that all the values in
the Excel are available and try again.
if this is not the case then please paste the error you are getting.
Thanks
Marked as answer by Ming Xu - MSFT on Jun 30, 2012 12:25 PM
On the table you are trying to import to, change all the varchar columns to varchar(MAX). Probably you are hitting a row where the data is too big to fit in your varchar column.
-Tab Alleman
Marked as answer by Ming Xu - MSFT on Jun 30, 2012 12:25 PM
sivaganesh12...
Member
227 Points
308 Posts
how to import data from excel to database with full data of a table?
Jun 09, 2012 10:28 AM|LINK
here i just tried to import a datas from excell to database but it import half of the datas only not fully
in excell it has id data of 50000 data but in database only 1600 datas only copied
snh_algorith...
Member
260 Points
80 Posts
Re: how to import data from excel to database with full data of a table?
Jun 09, 2012 11:50 AM|LINK
which database u r using? Version?
sivaganesh12...
Member
227 Points
308 Posts
Re: how to import data from excel to database with full data of a table?
Jun 10, 2012 03:25 AM|LINK
sqlserver 2008 r2
Chen Yu - MS...
All-Star
21584 Points
2493 Posts
Microsoft
Re: how to import data from excel to database with full data of a table?
Jun 14, 2012 09:21 AM|LINK
Hi,
Would you please show us your import code? It will provide us more information about your problem.
Here is a KB about import data from excel to sql server, you could follow below link.
KB: http://support.microsoft.com/kb/321686
Thanks.
Feedback to us
Develop and promote your apps in Windows Store
sivaganesh12...
Member
227 Points
308 Posts
Re: how to import data from excel to database with full data of a table?
Jun 14, 2012 11:50 AM|LINK
I JUST USED RIGHT CLICK ON DATA BASE AND SELECT TASKS AND THEN TO IMPORT
I DIDNT USED QUERY
nilsan
All-Star
16940 Points
3719 Posts
Re: how to import data from excel to database with full data of a table?
Jun 14, 2012 12:56 PM|LINK
Generally it works, without any issue. You said it imported 1600 records and not all so, there must be some errors.
Blog | Get your forum question answered | Microsoft Community Contributor 2011
Chen Yu - MS...
All-Star
21584 Points
2493 Posts
Microsoft
Re: how to import data from excel to database with full data of a table?
Jun 15, 2012 02:34 AM|LINK
Hi,
If you meet any error when you import data, please post that error message.
Thanks.
Feedback to us
Develop and promote your apps in Windows Store
sivaganesh12...
Member
227 Points
308 Posts
Re: how to import data from excel to database with full data of a table?
Jun 26, 2012 09:15 AM|LINK
i will clearly tell u what was the error which i faced
mdfarhan
Member
100 Points
33 Posts
Re: how to import data from excel to database with full data of a table?
Jun 28, 2012 08:10 AM|LINK
You can import the excel without any error if the columns of the excel and the column in database table are same.
one of the thing came in to mind with your question is that may be in your excel some of the coluns values are missing (means the column which are not null in database table, you are passing as null values from the excel) make sure that all the values in the Excel are available and try again.
if this is not the case then please paste the error you are getting.
Thanks
TabAlleman
All-Star
15571 Points
2700 Posts
Re: how to import data from excel to database with full data of a table?
Jun 28, 2012 01:40 PM|LINK
On the table you are trying to import to, change all the varchar columns to varchar(MAX). Probably you are hitting a row where the data is too big to fit in your varchar column.