Extract Excel cell value into ASP form field

Hi
Can anyone please assist with this. Is there any way that I can extract
a specific cell value from an uploaded XLS sheet into an ASP form
field?

eg

MyXLS.xls - Sheet1 - cell A3 -----> MyFormField

Thanks
C.

RE: Extract Excel cell value into ASP form field

Craig,

You will have to save the Excel file to disk on the server after the upload.
Then, using the Jet Excel Driver, you can retrieve the value in your cell
and populate your form field with the value.

If you do a search on google or microsoft, you should be able to find some
pretty good references to using Excel as an ODBC/OLE DB datasource.



"craig.johnson@westleigh.co.uk" wrote:

> Hi
> Can anyone please assist with this. Is there any way that I can extract
> a specific cell value from an uploaded XLS sheet into an ASP form
> field?
>
> eg
>
> MyXLS.xls - Sheet1 - cell A3 -----> MyFormField
>
> Thanks
> C.
>
>