| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Character limit for DAO queries?
If there's a limit, I never met It. I made a lot of queries over 3K caracters....
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell character limit | Excel Discussion (Misc queries) | |||
| Character limit in textbox | Excel Worksheet Functions | |||
| Set Character limit in Column | Setting up and Configuration of Excel | |||
| Character limit in cell | Excel Discussion (Misc queries) | |||
| 255 Character Limit | Excel Discussion (Misc queries) | |||
![myl[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
