Excel database to website?

P

Pam

I would like to be able to take a database of our club members from excell
to fp2003 - only thing is that of course in the excel file the info goes all
the way across the columns, what I would like it to do is be in the form of
a mailing address such as this:

First Last
address
city, State Zip
telephone
url

is there anyway to make the excel file import into word or fp2003 so that it
reads as above instead of:

Name Address City State Zip Phone URL

???

thanks!
 
T

Thomas A. Rowe

You would have to use the FP database component, to display the data as you want.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
A

Andrew Murray

You can do a mail merge in word, using the excel file as your data source....you
can export the xls file to mdb (MS Access database format, which is what ASP
pages common use as opposed to SQL.).

Use the database interface wizard, and/or database results wizard.
a good tutorial is here: http://www.frontpagewiz.com which is a good "all
rounder" site dedicated to frontpage - use it as well as this Newsgroup to get
aquainted with frontpage, and what it can do.

To use databases with frontpage you need to host on a server supporting Frontpage
server extensions, ASP and IIS.
 
Top