Excel
(1)
ASP.NET
(1)
Database
(1)
Spambot
(1)
Killer
(1)
Mailto
(1)
F0235cdcb480
(1)
Filterable
(1)

Excel to Access, then via FrontPage to web

Asked By jeff otto
24-Oct-09 04:05 PM
I have a single large Excel table that I need to make viewable and filterable on the web by multiple simultaneous users.  The filtering needs to be on just a few columns, but each cell in those columns contains multiple terms concatenated together, so the filtering has to be based on text within the cells.  Besides outputting cell contents, the output needs to include hyperlinks to thumbnails (or embedded ones).

Is that possible if I create an Access database from an Excel spreadsheet, and put it on the web using FrontPage?

EggHeadCafe - Software Developer Portal of Choice
Spambot Killer ASP.NET Mailto: Hyperlink Control
http://www.eggheadcafe.com/tutorials/aspnet/9817ba6f-ba00-4523-9097-f0235cdcb480/spambot-killer-aspnet-ma.aspx

Anything is possible,- if you normalize your Access DB after you import the

Stefan B Rusynko replied to jeff otto
25-Oct-09 04:08 AM
Anything is possible,
- if you normalize your Access DB after you import the excel table data
- and are proficient at server side coding

It is not something "wizards" will do for you

--

_____________________________________________
SBR @ ENJOY (-:              [ Microsoft MVP - FrontPage ]
_____________________________________________


I have a single large Excel table that I need to make viewable and filterable on the web by multiple simultaneous users.  The
filtering needs to be on just a few columns, but each cell in those columns contains multiple terms concatenated together, so the
filtering has to be based on text within the cells.  Besides outputting cell contents, the output needs to include hyperlinks to
thumbnails (or embedded ones).

Is that possible if I create an Access database from an Excel spreadsheet, and put it on the web using FrontPage?

EggHeadCafe - Software Developer Portal of Choice
Spambot Killer ASP.NET Mailto: Hyperlink Control
http://www.eggheadcafe.com/tutorials/aspnet/9817ba6f-ba00-4523-9097-f0235cdcb480/spambot-killer-aspnet-ma.aspx
Post Question To EggHeadCafe