chunked of sql in VB recording

[bomal]

Hi,

hope someone can help me. I'm trying to, from excel via VB, connect to SQL Server and retreive records to an excelsheet.
I've created the VB code via VB recording BUT the VB editor shows only a part of the (pretty extensive) SQL code and uses ,,, to represent the remaining part of the code.

Why is that ? Can I do anything about it ?

I,ve tried to incorporate the missing SQL manually but then I get all sorts of syntax errors.

Many thanks in advance

 

[xlbo]

If you have ODBC connnections sorted out, you should be able to query the database using MS Query - no need to write the SQL, it'll do it for you and hold it in a .dqy file - have a look, you may like it ;-)
Rgds
~Geoff~