When exporting to EXCEL or ACCESS, ODBC is used to output the Excel spreadsheet or Access database. Exporting field names which correspond to ODBC keywords will cause error messages.
Analyzer handles this by checking field names being exported against a published “ODBC Reserved Word” list.
If Analyzer recognizes that an exported field name conflicts with a known ODBC reserved word, the field name is automatically altered to avoid conflict. In the example below, altered field names are listed in the Command Log once the Export command is run:
@ EXPORT FIELDS ALL EXCEL TO odbc2
Field name DATE is an ODBC reserved word; changed to DATE101.
Field name TIME is an ODBC reserved word; changed to TIME101.
Field name MIN is an ODBC reserved word; changed to MIN101.
Field name DAY is an ODBC reserved word; changed to DAY101.
20 records produced
Output to odbc2.xls is done
Since the published “ODBC Reserved Word” list is not fully up to date, from time to time Analyzer will export a field name that is an actual ODBC reserved word but was not in the list and so was not fixed. In this case, the following ODBC driver error message pops up and appears in the Command Log after the Export command is run:
@ EXPORT FIELDS Fillie Note ACCESS TO "odbc123"
(-3553) Syntax error in field definition. Check field names for ODBC reserved word.