Click here to Skip to main content
15,937,186 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I need urgent help with importing unstructured data from excel to SQL Server
where columns of sql table are not in first row in the excel sheet

Excel sheet format is like the following
first name on first row
last name is on second row and second column B
date on third row and on column D

I will open connection to excel sheet and start copying data into sql Table
please help
Posted

1 solution

If you are using MS SQL import wizard, there are options how to map the columns.

http://www.databasejournal.com/features/mssql/article.php/3580216/SQL-Server-2005-Import--Export-Wizard.ht[^]
 
Share this answer
 
Comments
Member 4675195 21-Nov-10 2:24am    
the sample is great but only if the first row contains the column name
which is not my scenario plz check my post in ASP.net forum so you better understand what i want
http://forums.asp.net/t/1623540.aspx

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