hi<BR>I have a question. i want to read datafrom a excel work sheet which is in the browser window and trasfer all the data in that sheet to a Access database. How it is possible. pl. help me<BR><BR>reddy
If you go to www.asptoday.com they have a bunch of articles for dealing with excel in asp. This sounds like it might be complicated. I wish you luck in your search.<BR><BR>sorry I couldn't help on this one.<BR><BR>However, if you don't need to do it programatically, that is easy. Just save the worksheet to a file on your computer, then go into access and go to File -> get external data -> import and go through the process that way.<BR><BR>programatically however, I have no clue whatsoever<BR><BR>mj
If it is just one time then just copy and paste append in Access table. The table should already be created of course having all the fields pertaining to the spread sheet columns.<BR>-- However if you want to use ASP to do this, there is "TDC" tabular data control that u can very well use to transfer the date, only u will need to take the file to the web server first in a delimited format.