Excel DAta Import Eifion Evans 4/19/2007 10:46:01 AM Hi Our company uses Pegasus Opera a Visual Foxpro Accounting package. We have numerous pivot tables linked into tables from the accounting package. In the last few days the accounting software has been upgraded and this time has installed the software into a new folder on the server; therefore all the spreadsheets are linked to the old data. Will changing the pointer to the database in the Visual FoxPro DSN allow the data to be linked the new accounting data? If we have to recreate the pivot tables we have another issue hopefully you can help us with. Within Excel we go to New Database Query and can create the query, however as we add tables in MSquery the first couple are ok then the third and fourth can take hours to add. MSQuery consumes about 50% of the processor on a dual core machine and memory used continuously increases to over a gb, if the tables can eventually be added then the speed of the query is fine. IS there anything we are doing wrong or is there a setting in MSQuery to improve this? Thanks Eifion Evans

Re: Excel DAta Import Dick Kusleika <dkusleika[ at ]gmail.com> 4/23/2007 4:48:41 PM On Thu, 19 Apr 2007 03:46:01 -0700, Eifion Evans <EifionEvans[ at ]discussions.microsoft.com> wrote: [Quoted Text] >In the last few days the accounting software has been upgraded and this time >has installed the software into a new folder on the server; therefore all the >spreadsheets are linked to the old data. > >Will changing the pointer to the database in the Visual FoxPro DSN allow the >data to be linked the new accounting data? > I don't think changing the DNS will do it, but I've never tried. Excel stores the database location in up to two places which you can change with VBA. See http://www.dicks-clicks.com/excel/ExternalData5.htm#ChangeConn for details on how and where to change it. -- Dick Kusleika Microsoft MVP-Excel http://www.dailydoseofexcel.com

Re: Excel DAta Import eifion 4/24/2007 8:56:04 AM Dick I will have a look at that thanks Eifion "Dick Kusleika" wrote: [Quoted Text] > On Thu, 19 Apr 2007 03:46:01 -0700, Eifion Evans > <EifionEvans[ at ]discussions.microsoft.com> wrote: > > >In the last few days the accounting software has been upgraded and this time > >has installed the software into a new folder on the server; therefore all the > >spreadsheets are linked to the old data. > > > >Will changing the pointer to the database in the Visual FoxPro DSN allow the > >data to be linked the new accounting data? > > > > I don't think changing the DNS will do it, but I've never tried. Excel > stores the database location in up to two places which you can change with > VBA. See http://www.dicks-clicks.com/excel/ExternalData5.htm#ChangeConn for > details on how and where to change it. > -- > Dick Kusleika > Microsoft MVP-Excel > http://www.dailydoseofexcel.com >