Load data through external script

[alwinsch]

Hi all,

I created a Txt file, which contains a select statement from SQL.

I want to use this text file as my datasource for qvw file.

But

- I want to load the same script 3 times... because we have 3 identical DB's

How can i do this?

Do i create in my QVW file

first the OLE DB provider and after this sentence

i reference to the extern script.

then i create a new OLE DB (to the next Database)

and again load the sript?

Or is there another way?

Kind Regards,

Alwin

[sreenivas]

Create 3 tabs and each tab to particular db connection string and load the data.

[alwinsch]

So i use in my final QVW file:

OLEDB CONNECT32....

include (external.txt)

Oledb connect 32....

include (external.txt)

is this what you mean?

[sreenivas · Accepted solution]

yes