Hi All Can anyone advise on the use of using databases in Excel format in your webpage? I am almost finished compiling my * first* webpage and I'm using Netscape Composer. I have 2 databases given to me by a listmember in Excel. I have no basis for my worry other than that I haven't run across too many of them on the web, so I don't know whether I should try to use it or just convert it to a regular table. Actually, I did try using one excel sheet in the webpage a few weeks ago. I got some error message and I ended up doing the whole thing over in a table -- I just couldn't handle yet another new thing to tackle! <G> Thanks for any help! Linda

Hi Linda - Well, I can tell you how I use Excel. I receive data from people who type up marriages for the Woodruff County web pages, and do so in a word processor. I then bring the data I receive into Excel (I use Excel 97, it's simpler, as I recall). In Excel, I get it formatted like I want - centered, text sizing fairly small, etc. I then save it as HTML. I take the HTML code into my HTML editor, and make changes, modifying the background and text colors in the Body statement, and add a few more things (titles, etc). But I do use the HTML that Excel produces. My hunch is that using the HTML works better than trying to use the Excel, although I've never tried to use the latter. I've seen pages that used Powerpoint, rather than the Powerpoint code, and didn't like it as well. FYI. Hope this helps- Gloria ======= >Hi All > >Can anyone advise on the use of using databases in Excel format in >your webpage? >I am almost finished compiling my * first* webpage and I'm using >Netscape Composer. > >I have 2 databases given to me by a listmember in Excel. I have no >basis for my worry other than that I haven't run across too many of >them on the web, so I don't know whether I should try to use it or >just convert it to a regular table. > >Actually, I did try using one excel sheet in the webpage a few weeks >ago. I got some error message and I ended up doing the whole thing >over in a table -- I just couldn't handle yet another new thing to >tackle! <G> > >Thanks for any help! >Linda > > >============================== >Create a FREE family website at MyFamily.com! >http://www.myfamily.com/banner.asp?ID=RWLIST2

I, too, have engaged in invigorating tussles with Excel trying to get columns neatly lined up for lists of data. I had some MS Access databases passed to me, and then take the data to Excel to "clean up." I find that when I save what I've done to HTML, it creates a HUGE file. I also use FrontPage. Here is what I ended up with, by (lots of!) trial and error: In MS Access: View - Datasheet View Highlight and Copy desired section In Excel: Paste into spreadsheet Make any necessary formatting changes Save as: (this is key) Formatted text, space delimited This saves it as a .prn file In FrontPage: Insert File Choose "as text" Choose "formatted paragraphs" The columns come out nice and neatly lined up. Then save FrontPage as normal. This creates a fraction of the size file that I had experienced when saving as HTML from Excel. Sandy Redmond Webmaster, Calhoun County MIGenWeb http://www.rootsweb.com/~micalhou