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

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

WojciechG

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Placing a Pivottable in A1 0
How to create a Pivottable with text only data 1
sqlite-odbc write conflict 2
Excel 2010 PivotTable Oddity 2
ODBC Microsoft Access Driver Login Failed 0
Excel Pivottable Writeback 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
The Number Format button missing in Pivottable 0

Top