MySQL or ODBC

[jferree]

Hi,

Anyone been able to export to a MySQL DB using ODBC?

Did you use Macros or the export utility?

Any advise would be appreciated.

Jim

 

[Rod Gill]

Hi,

Always use the File, Save As menu and click the ODBC button. Visit the mySQL
web site and make sure you have the latest MySQL ODBC drivers installed.

 

[jferree]

Seems to work except for when it wants to use the type "longchar" for
at least one of the fields. MySQL does not support this field type.

Is there a work around?

 

[Rod Gill]

Not if the MySQL driver doesn't support or convert it.