ExcelBanter - Character limit for DAO queries?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Character limit for DAO queries? (https://www.excelbanter.com/excel-programming/293949-character-limit-dao-queries.html)

myl[_2_]

Character limit for DAO queries?

Our company just upgraded to Office 2003. Previously, we had a fe
macros that would use the ODBC/Query add-ins and run SQL queries
putting the output
on a worksheet.

In Excel 2003, the Add-ins/libraries no
longer exist, so I have been replacing
the old code with code using DAOs.
In the old code, there was a 256 character limitation for quer
strings. Is this still the case with a DAO

--
Message posted from http://www.ExcelForum.com

JFD[_2_]

Character limit for DAO queries?

If there's a limit, I never met It. I made a lot of queries over 3K caracters....

All times are GMT +1. The time now is 08:10 PM.