Read from other workbook adodb

[jaryszek]

Hi,

to read SQL statement from other workbook i am using:

Please Login or Register  to view this content.

and this is not working.

And i found in internet that in the end of it should be :

Please Login or Register  to view this content.

Still this is not working.

What is correct sytax for it?

Best,
Jacek

[xlnitwit]

The correct type is 'Excel 12.0 Macro' for an xlsm file, but for a simple SELECT statement, why not just open a connection to that workbook?

[jaryszek]

hi xlnitwit.

thank you.
You are fast

MY whole code is :

Please Login or Register  to view this content.

IT is left join.
Hmm why to open connection if i can add [Macro 12.0] in the end of statement? (and where i should add this? This is not working).

Best,
Jacek

[jaryszek]

And other question is:

How to open different connection for previous workbook and combine it with connection to current workbook?

Open 2 connections and how to create SQL for these?

Best,
Jacek

[xlnitwit]

I suggested opening a connection because there was no mention of any other tables in your original post.

The syntax would be something like this

Please Login or Register  to view this content.

[jaryszek]

ok thank you xlnitwit!

I am checking this !

Best,
Jacek

[jindon]

Try change to

Please Login or Register  to view this content.

[jaryszek]

Amazing working like a charm!!