Split from - http://www.daniweb.com/forums/thread182138.html

i also have the same problem. i want to store my excel sheet data in database having same fields as in sheet.
please help me out

>Import data from Excel to SQL Server Database

Use Oledb namespace classes.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.