-----Original Message-----
I'm trying to insert an Excel Database for search
purposes. I'm not able to figure out what the problem
is, but I'm not figuring it out -- I read books, and went
through the "learn 2 series" -- nothing there. How can
I use an excel spreadsheet containing data, then have
the user of my website type in there ID to find all the
information that pertains to that ID?
There's no good way to do this.
The bad way is to set up your spreadsheet as a data
source, as described in MSKB Article 268948, "HOW TO: Use
an Excel Worksheet as a Data Source in FrontPage 2000,"
and then use the FrontPage Database Results Wizard to
query the data source. Of course, you would set up a
criteria for the column containing the IDs you want to
filter.
The problem with this is that Excel makes a lousy
database. Seemingly trivial practices, like mixing alpha
and numeric data in the same column, can have catastrophic
results.
The superior approach is to export your data to Access,
and then query the Access database.
Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*========----------
|\=========------------
|| Microsoft Office FrontPage 2003 Inside Out
|| Microsoft FrontPage Version 2002 Inside Out
|| Web Database Development Step by Step .NET Edition
|| Troubleshooting Microsoft FrontPage 2002
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/=========------------
*========----------
