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
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