Execute large SQL/Insert

[Si]

Hi Guys

I have a very large SQL statement that i am executing from VBA against an
Access database.

I keep getting errors and i believe that it is due to the SQL being too
long, is there any way that i can execute a large SQL Statement?

This is my statement:

INSERT INTO tblCandidate ([CV Details]) VALUES ('" & wordRange.Text & "')
WHERE CandID = " & CandID

The volume of data comes from the Word Range and exceeds 1000 chars.

Thanks Si

 

[Gary Miller]

Si,

Better watch out. There are some very sharp gals haunting
these groups as well <gr>.

Actually, your SQL statement is very short. Apparently it is
the length of the data that you are inserting that is
probably too long. Access 'Text' fields have a limit of 255
characters so if you are inserting over 1000 you are doomed!

What you can do is change your field that you are inserting
into from a text field to a 'Memo' field that is very
flexible on the amount put in, although a bit more limiting
for searches.

Good Luck,

Gary Miller