Start a new topic

Error code - Microsoft

Hi:

 

I have received the following error message:

ERROR [42000] [Microsoft][ODBC Excel Driver] Syntax error in FROM clause

 

Has anyone else received this error?  Does it have something to due with upgrade of Microsoft Office that is not compatible with Omatic?

Solutions?

Thanks

Gwenanne

1 Comment

Hi Gwenanne,

Are you using the MasterID option when importing your gifts, and using the Excel file translation method?

You can find this in your IOM profile under Gifts:

image



Check the header row in your MasterIDs file and make sure there aren't any spaces and that you have all of the columns (even if you aren't importing values for them):


image



Please let me know if you have any other questions.

Thank you
Amanda
Omatic Software

Login to post a comment