ODBC query length within VBA code

[poiu]

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

 

[Firefly2012]

I know in the past I've executed very long SQL strings via ADO/ODBC connections so I don't *think* there is a (practical) limit. i suspect it is more to do with the way the macro recorder records the steps taken in creating the ODBC query.