Search results

thanks. That's probably a good practice. But after some investigating, it turns out that length isn't the issue. It's special characters in my string like * and '. Parameters should fix it (found in link below). http://www.vbforums.com/showthread.php?t=552665

ADO Execute SQL string length (SOLVED) I'm trying to send values from an excel workbook to an Access database using VBA. Problem is that sometimes strLongString gets really long, and apparently the Execute command can't use any SQL string longer than ~306 characters, so the SQL statement gets...

an array is the only way. And you probably don't need to redim. Just set the array size to whatever the maximum amount of variables there will be. And when you loop through it later, just tell the loop to stop when it hits a blank element.