Import a large SQL query definition from a text file

[Saintor]

The query definition has about 75 lines. It is part of an Excel VBA routine in which I connect to a MS SQL database using ADO. One reason to go with an external file is to avoid adding the line break characters such as " & _ at the end of every line.

I am able to retrieve my file with VBA and pass it to string variable, no problem. When I paste it in Microsoft SQL Studio, it will trigger errors. My query definition becomes 4 very long lines of 2000 characters and it will truncate anywhere like a middle of a word.

Also just a note to mention that when I retrieve the file, by code I replace a variable with an actual part number. For example, 'SC1' can become '0270'

Obviously I am doing it wrong. Can somebody guide me in the right direction or offer an example. TIA.

[millz]

You probably have to show your code at least, and maybe the SQL too, at least a few complete statements to know what you're actually doing.

[Saintor]

Ok, I guess that I just had to learn about stored procedures and how to start them with VBA.* *Done.