Error:[ODBC FMP Driver]Invalid Character Value.

[laker_42]

I keep getting the following error when trying to bring my table into SQL Server via ODBC:

[DataDirect][ODBC Sequelink Driver][ODBC Socket][DataDirect][ODBC Filemaker Driver]Invalid character value. Error in column 62.

I look at field #62 and it is a global field with nothing in it. I can't figure out what is going on. I have other tables that I imported that had global fields but not this one. Any input would be appreciated!

Thanks!

John

[laker_42]

Never mind, I figured it out. It ended up being two calculation fields that were doing a count(Related field). For some reason it didn't like this. I changed the calculation to IsEmpty(Related field) and it works.

Admins, you can delete this post if you would like.

Thanks!

John