Microsoft KB Archive/175445

From BetaArchive Wiki

Article ID: 175445

Article Last Modified on 9/1/2006


  • Microsoft Excel 97 Standard Edition

This article was previously published under Q175445


If you create a Microsoft Excel worksheet form by using the Web Form Wizard, and then submit data with the form, you may receive an error message that is similar to the following:

Error Performing Query

[State=37000][Error=-3502][Microsoft][ODBC Microsoft Access 7.0 Driver] Syntax error in INSERT statement

NOTE: The error message you receive may vary depending on the database to which you submit data.

The data is not added to the database.


This behavior occurs when you use a field name with the label "date" (without the quotation marks).


To resolve this behavior, rerun the Web Form Wizard and do not specify "date" as a field label. Instead, use a more descriptive label, for example, "submit_date."


This behavior is by design of Microsoft Excel.


Some words are reserved and shouldn't be used when you submit data by using Open Database Connectivity (ODBC). "Date" is one of these reserved words. Because you may need to set up a system data source on the Web server and use an ODBC driver to submit data with the Web Form Wizard, you may receive error messages when you use some reserved words.

For additional information, please see the following article in the Microsoft Knowledge Base:

125948 MSQUERY: Reserved Keywords in MS Query

NOTE: You must establish a system data source on the Web server only if you click "Microsoft Internet Information Server with the Internet Database Connector" in step 3 of the Web Form Wizard.


For more information about the Web Form Wizard, click the Index tab in Microsoft Excel Help, type the following text

web form wizard

and then double-click the selected text to go to the "About setting up your data gathering system" topic.

Additional query words: XL97

Keywords: kbprb kbweb KB175445