Concatenating SQL strings in VBA

[chiangwei]

I have a problem when concatenating strings in VBA

I have parts of a SQL query string stored in several cells in Excel which I concatenate to form SQL queries. The resulting SQL query looks correct but it doesn't work. I copied and pasted the exact same SQL query string saved into a text file and there was no problem.

Anyone have any idea why that happens?

 

[xlbo]

Shouldn't be a problem - maybe you have some extra spaces or characters in your cells ?? Rgds
~Geoff~

 

[danvlas]

...or not enough spaces???
Maybe the concatenated result looks like:

Select WhateverField FromWhateverTable Where...

It happens all the time...

Daniel Vlas
Systems Consultant
danvlas@yahoo.com