Hi
I have an excel spreadsheet I want to query online where a use inputs parameters and the relevant data is then shown, what is the best method/tools for going about this?
Thanks
millsy007
0
Light Poster
Recommended Answers
Jump to PostExcel isn't a web application, so I assume you're actually referring to converting the spreadsheet to a database and then querying it?
In that event, there are numerous possibilities, Perl, PHP with MySQL, anything with the capacity to query a database...
The most common method for a web …
Jump to PostThat would be the least complex method. And for a novice, I would suggest the PHP/MySQL method. (I would use Perl, but that's MY thing.)
In this case, set up your MySQL database, convert the spreadsheet you want to a format MySQL can import, import it and that's done. …
Jump to PostMy personal recommendation - point your person to PHP & MySQL for Dummies. Seriously. It has enough to get started programming PHP and MySQL. Assuming this is supposed to be an online application, I have doubts that many hosts offer Microsoft Access. But nearly all of them offer MySQL, which …
All 9 Replies
Dandello
8
Posting Whiz in Training
millsy007
0
Light Poster
Dandello
8
Posting Whiz in Training
millsy007
0
Light Poster
Dandello
8
Posting Whiz in Training
drjohn
56
Posting Pro in Training
Dandello
8
Posting Whiz in Training
teedoff
3
Posting Pro
Dandello
8
Posting Whiz in Training
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.