long sql

[bbwolff]

i have a stupid problem
i have a long sql where i insert into database 30+ values
it's to long for the editor (line to long) and if i try linebreaks _ it returns an error.
what to do

 

[CJ_London]

what to do indeed. It all depends on the error, but you haven't told us what it is and I really don't want to guess which of 100 possibilities it may be. So, if we know what error you are getting we can be in a position to help. Better still, post your sql code as well.

 

[bbwolff]

No error
I can't even write it as it's to long for the editor and if i try to break it into lines with underscore it turns red.

 

[spikepl]

SO how about applying some sense? If you do not know how to break an SQL statement, or any VBA statement, into multiple lines, then google your problem.

Then take a short SQL statement and break it up so that it is on, say, 3 lines. Once you know how to do that, then you'll be able to do it with your original.

And put the entire statement into a string, and debug.print the string. http://www.baldyweb.com/ImmediateWindow.htm