XL97: Error Submitting Data by Using Web Form Wizard Worksheet

• Microsoft Excel 97 for Windows

SYMPTOMS

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

The data is not added to the database.

CAUSE

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

RESOLUTION

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."

STATUS

This behavior is by design of Microsoft Excel.

MORE INFORMATION

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 articles in the Microsoft Knowledge Base:

   ARTICLE-ID: Q125948
   TITLE     : MSQUERY: Reserved Keywords in MS Query

   ARTICLE-ID: Q133177
   TITLE     : INF: Changes to SQL Server 6.0 That May Affect 4.2x Apps

REFERENCES

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

   web form wizard