IIS - 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
Excel
(1)
ASP.NET
(1)
Database
(1)
Spambot
(1)
Killer
(1)
Mailto
(1)
F0235cdcb480
(1)
Filterable
(1)
Stefan B Rusynko replied to jeff otto
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
save a flat export data file as an excel file IIS Hi all, I have a question for you. I have a .csv file I need to extract part of data from this file but save it as an excel file. The data in this excel file will be imported into an Access database. The reason I have to save it into an excel file is Access program only accept excel data file, but not flat text file. Can you tell me how to save extracted data into an excel file? Thanks. - - Betty IIS ASP Discussions SQL Server 2005 (1) Excel (1) ASP.NET (1) NoWebContent (1) ArticleID (1) Database (1) AccessTable (1) Pedant (1) Why
development. Specifically, I have to develop an ASP program which will read data, write out Excel spreadsheets, write out pipe-delimited files, and update a back-end SQL Server database. Anything that anyone can point me to would be GREATLY appreciated. Is there any sample advance for your help. PSULionRP IIS ASP Discussions SQL Server (1) UFNVTGlvblJQ (1) PSULionRP (1) Excel (1) ASP.NET (1) Database (1) Methinks (1) Emailaddress (1) = ?Utf-8?B?UFNVTGlvblJQ? = wrote on 12 aug 2008 in to dots in my emailaddress) 1. Decide whether you wish to use classic ASP or ASP.Net. You will need to do some resarch to make this decision. This is a classic
Export very large excel hang IIS IIS Here's the long story short. At work we have to real-time generate a report(excel format) which involves a number of table joining. So to export into excel contentType 'application / vnd.ms-excel' is used, and data are written as table, looping each row of recordset data as clearly here but I appreciate all the helps I can get. Thanks. IIS ASP Discussions Excel (1) ASP.NET (1) IIS (1) Database (1) Report (1) AnthonyScenario (1) ContentType (1) Newbro (1) involves by until the I'm
Plz do help me im in difficult situation IIS i have to read an excel file and on that excel file i must calculate the sum of the 2nd column and that sum should be stored on the access database which contains tablename "ben" and the fileds will be srno(auto) number date(filename of the excel) total(sum of 2nd column) This should be done using asp.net The total of the sum should be displayed on the other excel sheet im using .net2003 Plz do send me the code for this. . . . I have to use oledbdataadapter and oleddconnection * ** Sent via Developersdex http: / / www.developersdex.com * ** IIS ASP Discussions Database (1) Excel (1) Developersdex (1) Oledbdataadapter (1) Oleddconnection (1) Homework (1) Column (1) Class (1