Click here to Skip to main content
15,868,164 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
how to load data from multiple Excel sheets to multiple OLE db tables?
but these sheets are having different structure.
so can it possible or not?
Posted
Comments
Abhishek Pant 10-Jun-14 8:51am    
load data from a excel sheet to dataset from multiple sheet then enter them to the tables columns from the defined columns from the dataset.

1 solution

Look at this article[^] and download the example package.

You may create SQL queries for every Excel sheet and specify a target server, database, and a table.
 
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