Click here to Skip to main content
15,867,939 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
i want to convert data excel to sql without any changes .is this possible?????

What I have tried:

i created database in ssms and then import data into sql . table is created in database but when i convert huge amount of data data became random . like slno not in manner. how can i solve this problem????????
Posted
Updated 27-Jul-17 23:56pm
Comments
Richard MacCutchan 30-Jun-17 3:59am    
"how can i solve this problem?".
Maybe by fixing your code. But if you want help here then you need to provide some proper details of what is going wrong.
Member 13284521 30-Jun-17 4:39am    
my actual data in excel format and i want to convert that data into sql database without any changing. i try ..my data is converted into sql in table format but problem is data not in sequence .
Richard MacCutchan 30-Jun-17 4:58am    
Then you need to do some investigation with your debugger to find out why this happens. You cannot expect anyone here to guess what your code is doing.
Member 13284521 30-Jun-17 5:01am    
thank you so much
Lazar Jovovic 3-Jul-17 4:16am    
As people already said - you need to provide us with more details to figure out the issue.
Anyway, if I'm not mistaken, you have data in Excel format that you want to load to SQL database (confirm if this is correct). One of the most efficient way to achieve this is by using SSIS tool.

1 solution

I think your slno in excel, may be a char format, so that's the reason sql cann't be sort properly.

you should check your table design, and check slno format.

and you also make a query from excel with concatenation.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900