Unanswered question-Re: Using data from a worksheet

  • Thread starter Thread starter Malcolm Walker
  • Start date Start date
M

Malcolm Walker

Using FrontPage 2003 SP3

This is a message (edited) I posted to open an earlier thread which died
before an answer relevant to my situation appeared. In reposting I am
hoping for useful guidance.

Details of my golf club's fixtures, events and bookings are listed in a
worksheet on a daily basis for a calendar year and frequently edited for
changes and new bookings. There are 11 columns of data and this work is
done in the club's office. The current worksheet is emailed to me monthly.

To get started I created a page for each month by saving from the
worksheet each month's data as a .csv file, importing that file into
FrontPage, opening it in Notepad in FrontPage (Open with), copying and
pasting into each new page and using Table | Convert | Text to Table to
create the table of data. I then formatted the table using HTML.

However I cannot see a way to update the data other than manually!
Ideally I would want to delete the data from its table and copy and
paste the newly issued data into the table not disturbing the formatting
(similar to the copying and pasting of data in Excel).

But elsewhere I have been told to use ASP (of which I have no knowledge)
as a better way of updating the pages. I have since tested the server,
provided by a member of my family and as ASP is not supported I am need
of an alternative. Is there a way more suited to my limited abilities
while continuing to use FrontPage?

Malcolm Walker
 
What I would be doing is putting that information into an Access DB, and
having a query inside of that db to only pull the current months
information. In FP then, you can use a Database Results Wizard to pull the
data from that query.
As you are using '03 and I was on 2k, there was advancement done to FP- so
you may have a little more that you can do in FP than I could
 
Mike, Thank you for your reply. But in my message . . .
as ASP is not supported (i.e. on the server I am using) I am need of
Click to expand...
an alternative.

From my very limited knowledge the Database Results Wizard cannot be
used without ASP or ASP.NET. Please correct me if (hopefully!) I am wrong.
 
That information is correct- asp / .net are are required for out-of-box
success
However, there are similiar options that can be done in other scripting
languages such as PHP- it will not be a drop in place project for FP,
instead a custom script would be needed. Expression Web V2 beta does have
PHP support in it, the best person to ask about it would be Veign in the
microsoft.public.expression.webdesigner NewsGroup
 
Following on from Mike's answer - you can still do this in frontpage without
asp.

Create a form and save the results to the private folder (which are csv).
It is very simple to code a button to pull this information into an access
database - so you don'r need to cut and paste. Or, if you want, you can
automate this by using windows scedular to run an autoexec macro in your
access db.

Mind you I think if you ask your server IT they may be able to handle the
data in mysql (which I think most servers can run). But, unless you have
zillions of records, access is much better at this type of thing
 
Back
Top