exporting excel file to database

[abhijitjathar]

i have one excel file & wants to insert that file with records in to data table??? can any one help me to do so????

[Natza Mitzi]

Your question is not focused but the general structure can be as follows: Open the file using an OleDbConnection (you can find the connection string at connectionstrings.com) Read the contents into a DataTable using a SELECT * FROM [table_name] Connect to the db you wish to export the data to Create the table and columns Write the table

Natza Mitzi

[MumbleB]

An easy way is to use FileHelpers. Check site www.filehelpers.com[^]

Excellence is doing ordinary things extraordinarily well.