Read columns and sheets in Excel and Save to DB

[Lost User]

Hi, How to read sheet and columns in Excel and Save to DB. Sheet are table names Columns are Field names in table. Please share the links Guhananth.S

[Jens Meyer]

Hi, try to take a look at the following topic: linked servers. With them you can access excel files like a database. Every sheet is its own table. Alternatively you can try to read the file using oledb-driver or ADO.Net Regards Jens

When in trouble, when in doubt, run in circles, scream and shout

[Tej Aj]

check this post to save read excel sheets and each columns from the sheet http://www.opexsolution.com/forum/viewtopic.php?f=15&t=61&p=186#p186[^]