Interfacing a working spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I put an Access DB on my website, using the DB interface wizard in FP 2003.
It seems to work fine. Then I created a spreadsheet page in the website,
hoping that I could edit the spreadsheet online. Linking to it however, is a
problem. I am assuming I need to imitate the interface information that the
wizard created but I don’t even know what I am looking for. Could someone
point out a solution that would let me post a working spreadsheet as the db
interface wizard lets me post a working db?
 
See http://support.microsoft.com/default.aspx?scid=268948

IMHO you would be better served doing it all in Access

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|I put an Access DB on my website, using the DB interface wizard in FP 2003.
| It seems to work fine. Then I created a spreadsheet page in the website,
| hoping that I could edit the spreadsheet online. Linking to it however, is a
| problem. I am assuming I need to imitate the interface information that the
| wizard created but I don’t even know what I am looking for. Could someone
| point out a solution that would let me post a working spreadsheet as the db
| interface wizard lets me post a working db?
 
You don't. You store the data in Access, then if needed, you can either write ASP script that will
generate a Excel Spreadsheet dynamically on the web or you download the Access database and export
the data as a Excel Spreadsheet.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

paulgallanter said:
OK, How do I get an accessible, editable spreadsheet format in Access?

paul

Stefan B Rusynko said:
See http://support.microsoft.com/default.aspx?scid=268948

IMHO you would be better served doing it all in Access

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|I put an Access DB on my website, using the DB interface wizard in FP 2003.
| It seems to work fine. Then I created a spreadsheet page in the website,
| hoping that I could edit the spreadsheet online. Linking to it however, is a
| problem. I am assuming I need to imitate the interface information that the
| wizard created but I donâ?Tt even know what I am looking for. Could someone
| point out a solution that would let me post a working spreadsheet as the db
| interface wizard lets me post a working db?
Click to expand...
Click to expand...
 
Back
Top