Connection Advice

[pgalvezt]

Time ago I read a post about how connect many bases with same tables. In that case it created like a Link tables that Had the follows syntaxis:

OLEDB CONNECT TO [Provider=VFPOLEDB.1;......................

LOAD*, 'Site1' as Source;
LOAD

FieldA

FieldB

FieldC

SQL SELECT *

FROM `A_20`

Where FieldA =1 And FieldB <> 5;

LOAD*, 'Site2' as Source;
LOAD

FieldA 

FieldB

FieldC   

SQL SELECT *

FROM `A_20`

Where FieldA =1 And FieldB <> 5;

//And so on

Is the best way?

I have many folders (its like have many excels files from differents folders and with the same tables)

Example qvw. Goes January 2012 February 2012.  January 2012 other base.

Thanks