How to use different type Query for Excel PivotTable? (ODBC)

  • Thread starter Thread starter Jerry Huang
  • Start date Start date
J

Jerry Huang

How to use two different type of Database Query for Excel PivotTable? (ODBC)

My PivotTable gets data from Microsoft Query by ODBC. But I can not get two
different type database for ONE PivotTable. For example, one table is *.dbf,
the other is *.btr, Can i use these different table for ONE PivotTable?

I know Crystal Report can do it. How about Excel PivotTable?
 
try Vb, ADO programs or SQL.Request function (Excel ODBC Add-In) with "SELECT....IN... UNION SELECT....IN... " statement. I do such a queries into another file and make PivotTs basing on it
 
Back
Top