Getting data from MS Excel to ASP.

rupen · August 11th, 2005, 05:22 AM

Hi All,
I have a very strange requitm.
what my client want is that he will enter data in excel sheet,
my applin in asp will capture data from there.

any tip, link??
Thanks in advance.:)

Rupen Anjaria.
We CAN'T avoid problems, but can solve it.

rupen · August 11th, 2005, 05:29 AM

Further,
1)Excel is insatalled at client's pc and not at web server.
2)Generally these data will create some records in access table.

Rupen Anjaria.
We CAN'T avoid problems, but can solve it.

Greg Griffiths · August 11th, 2005, 04:16 PM

my best guess would be that you could use ActiveX to interact with the file on the client side and grab the data out before posting the data back to the server. The only other option I can think of would be to load the file using an ASP Upload type script, but you don't mention if you could process the Excel file on the server side.

rupen · August 12th, 2005, 04:04 AM

HI,
Which activex to use?
I can process the file on server-side
M still confu with this...

Rupen Anjaria.:)
------------------
We CAN'T avoid problems, but can solve it.

Greg Griffiths · August 12th, 2005, 04:01 PM

If the browser permissions allow it, you can run ActiveX on the client side to create an Excel reference t the file and then suck the data from there onto your webpage and then post that page to your server. http://www.greggriffiths.org/webdev/both/excel/ covers a similar idea.