Hello,
I am working on a project collecting keyword-delimited text data,
parsing it, and populating an Access database.
My problem, however, is that one of the datafields can be quite large
(5000+ characters) and my 'INSERT INTO' statement gives me a syntax
error. I can insert all of the other non-memo fields, but when I ad the
memo field it errors out.
I guess my question is - how long can I make the insert statement? I
have already tried removing the single quote, double quote, and
parenthese characters, to see if that was the cause of the error.
Any ideas?
Thanks in Advance,
- Mike Hewitt