Need suggestion: importing data into SQL Express

Tech-Archive recommends: Fix windows errors by optimizing your registry



I have an ASP.NET 2.0 website with a SQL Express database. I also have an
excel spread*** with alot of data on it. (If need be I can save it as a
CSV, XML, or whatever...)

I want the user to be able to import the data into an SQL Express database
(existing table) via a button on my ASPX page.

Do you recommend importing the data as XML into like a dataset, then
updating the SQL Express table with this dataset? If so, what's the easiest
way to update a table with an existing dataset? Additional
recommendations/suggestions appreciated...

Thanks!


.


Quantcast