Pivot Table connection String

M

Max Scott

Hi - i have a pivot table connected via odbc to a foxpro table. In excel
2003 I used to be able to use vb to change the connection string and thus
point to a different table. I'm now using excel 2007 and although the vb
statement says

..Connection = "ODBC;DSN=Visual
FoxPro Tables;UID=;;SourceDB=w:\FoxSys\Foxdos\This\Stk\rhs;
SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;
Null=Yes;Deleted=Yes;""


the sourcedb doesn't change from its existing ....\this\stk\nav. Am I
missing something uisng new connection strings>

Thanks

Max
 

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

Programmatically set UID & PWD in existing ODBC DSN connection string. 1
Excel VBA SQL Query Filename 5
Programmatically setting pivot sourcedata 0
Pass a command text in pivot table 0
cannot link Foxpro file as table, access2000 3
Using ODBC import 1
Importing FoxPro 2.6 DBF Into Access 2007 1
Connection files and pivot tables 0

Top