Max size of SQL String

V

vt

What is the maximum size of an MS-access SQL Query String?
I am trying to execute a insert query with about 6500
length SQL string from VB using dao. It throws a error
regarding conversion from character string to
uniqueidentifier.
Any inputs would be helpful.
 
J

JohnFol

I can't find an explicit limit, however this does seem an excessive bit of
SQL.

To try and solve it, what if you cut and paste the SQL into a query using
Access?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Strings Truncating at 255 Characters ? Why? 1
Replace or insert characters in text string 6
sql string as field data; ado? 1
Update Table Field Value with SQL Query 2
Insert data from SQL table into Access table 3
How do I execute multiple SQL statements in Access?? 3
01004 - 0 - [Microsoft][ODBC SQL Server Driver]String data, right 7
Simple Access Query using VBA 1

Top