Need suggestion: importing data into SQL Express
- From: "VB Programmer" <donotemailme@xxxxxxxxxxxxx>
- Date: Mon, 4 Sep 2006 13:53:33 -0400
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!
.
- Follow-Ups:
- Re: Need suggestion: importing data into SQL Express
- From: Cowboy \(Gregory A. Beamer\)
- Re: Need suggestion: importing data into SQL Express
- Prev by Date: Re: Connection Pooling With ASP.NET 1.1
- Next by Date: Re: DataBase Refresh
- Previous by thread: Re: Connection Pooling With ASP.NET 1.1
- Next by thread: Re: Need suggestion: importing data into SQL Express
- Index(es):