Click here to Skip to main content
15,867,330 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,

I have data from the client received in csv,text,excel formats.
The data types,number of rows and columns are not defined.
I want to gather the data into a table in sql, identifying and sorting the data on the fly.
Please send your inputs.
Thanks
Posted
Comments
Umer Akram 27-Jan-15 1:53am    
Well there are many ways to do this. i would suggest you to do it using Microsoft run time library. following is the link Building Packages Programmatically
deepakdynamite 27-Jan-15 6:03am    
Can you explain your requirements ??? When you don't know number of columns and names of columns, then how will you perform sorting on column???
Member 11404426 28-Jan-15 6:50am    
It is like,there will be 10 columns in the beginning and may increase dynamically.I have to identify the datatypes entered in the column fields to check anamolies if any and store them in a table having the column name,datatype,length

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