Manipulate Excel data and Export into SQL Table

[qberta1]

I have an Excel spreadsheet with several tabs. I am able to pull the data from the different tabs into ASP.NET and manipulate its content into one uniform DataTable.

Now I need to take this data and insert it all into a SQL table.

Is there any easy way of taking Excel data and inserting it all into a SQL table using ASP.NET?

Thanks!

Q.

 

[ca8msm]

If it's SQL Server probably the fastest option will be DTS or a bulk insert (can't remember who mentioned that one, sorry!).

Other options are to simply loop through each DataRow and run an insert.

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.