Hello,
I've recorded a macro that creates an ODBC connection.
Howevery the recorded macro does not have a full SQL query (I assume because I am using too many columns). If I replace the problem part of the query with just "*" then the whole table is imported correctly.
Please could you tell me if this is a known issue in Excel 2003? (is there a limit on the length of an SQL string?).
Thanks,
Poiu
I've recorded a macro that creates an ODBC connection.
Howevery the recorded macro does not have a full SQL query (I assume because I am using too many columns). If I replace the problem part of the query with just "*" then the whole table is imported correctly.
Please could you tell me if this is a known issue in Excel 2003? (is there a limit on the length of an SQL string?).
Thanks,
Poiu