Excel database to website?

  • Thread starter Thread starter Pam
  • Start date Start date
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!
 
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.
==============================================
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top