T
timothym
Hi!
I have a multiple worksheet .xls file which also contains various
formulas and sheet links. What I want to do is to create a web user
interface to allow a user to add data to the spreadsheet. However, I
think that an Excel spreadsheet may only be opened as a database but in
read only form through a web page. So, I tried to import the .xls file
form MSAccess instead. However, the problem is that only one sheet at a
time can be imported to MSAccess and all formulas seem to be lost. Is
there a process of keeping the links and all while importing the .xls
to .mdb? What I finally want to achieve is the ability to add new rows
to the database via the web. Is this possible?
Any help would be greatly appreciated!
Thanks,
Timothy
I have a multiple worksheet .xls file which also contains various
formulas and sheet links. What I want to do is to create a web user
interface to allow a user to add data to the spreadsheet. However, I
think that an Excel spreadsheet may only be opened as a database but in
read only form through a web page. So, I tried to import the .xls file
form MSAccess instead. However, the problem is that only one sheet at a
time can be imported to MSAccess and all formulas seem to be lost. Is
there a process of keeping the links and all while importing the .xls
to .mdb? What I finally want to achieve is the ability to add new rows
to the database via the web. Is this possible?
Any help would be greatly appreciated!
Thanks,
Timothy