webapp to load excel file into a dataset

Client will have to upload and then it can be pulled into a DataSet using
the Jet driver.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com
********************************************
Think outside the box!
********************************************
"Paul" <Paul@dotnet.itags.org.discussions.microsoft.comwrote in message
news:6E55D514-AE8F-4F47-A13D-746515775A3D@dotnet.itags.org.microsoft.com...

Quote:

Originally Posted by

HI I need to have a web application that will load excel file data into a
dataset and then write portions of it to an SQL database. Anyhow just
wondering if anyone knows if this can be done with the excel file on the
client machine or does it have
to be on the server?
thanks.
--
Paul G
Software engineer.

ok thanks for the information. So thinking I can have a webform that uploads
the excel file from the client machine onto a folder with write permissions
on the server and then load the dataset using the jet driver as you mentioned.
--
Paul G
Software engineer.

"Cowboy (Gregory A. Beamer)" wrote:

Quote:

Originally Posted by

Client will have to upload and then it can be pulled into a DataSet using
the Jet driver.
>
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com
>
********************************************
Think outside the box!
********************************************
"Paul" <Paul@.discussions.microsoft.comwrote in message
news:6E55D514-AE8F-4F47-A13D-746515775A3D@.microsoft.com...

Quote:

Originally Posted by

HI I need to have a web application that will load excel file data into a
dataset and then write portions of it to an SQL database. Anyhow just
wondering if anyone knows if this can be done with the excel file on the
client machine or does it have
to be on the server?
thanks.
--
Paul G
Software engineer.

>

and just in case you need the connectionstring to connect up with Excel, try
the ones at
http://www.connectionstrings.com/
--

Hope this helps,
Mark Fitzpatrick
Former Microsoft FrontPage MVP 199?-2006

"Paul" <Paul@.discussions.microsoft.comwrote in message
news:CB712062-0C86-4AD6-BB76-D87E8556173E@.microsoft.com...

Quote:

Originally Posted by

ok thanks for the information. So thinking I can have a webform that
uploads
the excel file from the client machine onto a folder with write
permissions
on the server and then load the dataset using the jet driver as you
mentioned.
--
Paul G
Software engineer.
>
>
"Cowboy (Gregory A. Beamer)" wrote:
>

Quote:

Originally Posted by

>Client will have to upload and then it can be pulled into a DataSet using
>the Jet driver.
>>
>--
>Gregory A. Beamer
>MVP; MCP: +I, SE, SD, DBA
>http://gregorybeamer.spaces.live.com
>>
>********************************************
>Think outside the box!
>********************************************
>"Paul" <Paul@.discussions.microsoft.comwrote in message
>news:6E55D514-AE8F-4F47-A13D-746515775A3D@.microsoft.com...

Quote:

Originally Posted by

HI I need to have a web application that will load excel file data into
a
dataset and then write portions of it to an SQL database. Anyhow just
wondering if anyone knows if this can be done with the excel file on
the
client machine or does it have
to be on the server?
thanks.
--
Paul G
Software engineer.

>>