MySQL Reference Manual for version 3.22.21. 15 MySQL ODBC Support MySQL provides support for ODBC by means of the MyODBC program. We hope somebody will port it to Windows 3.x. This will help shed some light on any problems. Only use double float fields.
Access fails when comparing with single floats.
Set the 'Return matching rows' option field when connecting to MySQL . Access can't always handle DATE columns properly. In some cases, Access may generate illegal SQL queries that MySQL can't understand. Note that this is a bug in Excel, because it automatically converts a string to a time. This would be great if the source was a text file, but is plain stupid when the source is an ODBC connection that reports exact types for each column.