PDA

View Full Version : select multiple foxpro databases for query



dmikester1
05-05-2010, 01:17 PM
Is it possible to select multiple foxpro databases for a query that will join a table from each database? Here is the DB code I have right now.

With xlApp.ActiveSheet.QueryTables.Add(Connection:=Array(Array( _
"ODBC;DSN=Visual FoxPro Database;UID=;;SourceDB=H:\209080C\;SourceType=DBF;Exclusive=No;BackgroundF etch=Yes;Collate=Machine;Null=Yes" _
), Array(";Deleted=Yes;")), Destination:=xlApp.Range("A6"))
.CommandText = Array( _
"SELECT Fmilmk, Fdescript, Flength, Fmat_spec, Fsource, Ordqty FROM H:\LindasExcelReportProject\209080C\mi mi" _
& " WHERE Fsource LIKE '%103268%'" _
)

I see that it selects the database where it says "SourceDB". Is it possible to select 2 databases there?
Thanks
Mike