T
The Sisko
I am attempting to transfer data from an Access2.0 db to an Excel
spreadsheet using the following code:
DoCmd TransferSpreadsheet A_EXPORT, 5, MySQL, "C:\OUT.XLS", True
This works fine if MySQL is a fairly short query. If however the query
starts getting around 60+ characters long it falls over.
Is anyone aware of a limitiation on the length of Query that MySQL can
hold ? If there is a limit is there anyway round it ?
Cheers,
PaulC.
spreadsheet using the following code:
DoCmd TransferSpreadsheet A_EXPORT, 5, MySQL, "C:\OUT.XLS", True
This works fine if MySQL is a fairly short query. If however the query
starts getting around 60+ characters long it falls over.
Is anyone aware of a limitiation on the length of Query that MySQL can
hold ? If there is a limit is there anyway round it ?
Cheers,
PaulC.