View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
myl[_2_] myl[_2_] is offline
external usenet poster
 
Posts: 1
Default 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