Excel as DataBase in Front Page

[wilde]

Have posted this same question on the Excel BB hoping one
place or the other will have some help.

Has anyone ever successfully used Excel as the DataBase
in Front Page, allowing users to update, add, etc. to the
spreadsheet??

I think I am close but now am getting an ODBC Excel
Driver error that says "Data type mismatch in criteria
expression" has occured. Aside from displaying the
spreadsheet correctly initially, I cannot make changes or
updates to it due to this error.

Any thoughts?? Thank You

 

[xmas]

Wilde,

The only thing I can find is...

http://support.microsoft.com/default.aspx?scid=kb;en-us;268948

NOTE: The same methods used to post to or query an Access database can also
be used to post to or query an Excel worksheet.

 

[Guest]

Yes, that is part of the definition process(but not
nearly complete by the way) that is used but from there
thru the DB connection, etc. it gets a little messy and
then when you finally publish to the web...the error
shows up. But thank you anyway.