Archive of Mr Excel Message Board


Back to General Excel archive index
Back to archive home

Data Tracking

Posted by Computerfreaks on February 11, 2002 1:58 AM
I have created an Excel database with the data tracking add-in, I then hoped to query it using the query wizard, however when I select the database as the source of the query it tells me there are no visible tables?????, I can't simply modify the database to have tables as it is autoformatted on creation and doesn't like being changed, any changes would mean I cannot add to the database using my template.

It strikes me as very stupid to nt allow a query to run from a database created in the same program!? i'm using office2000

Any help asap would be great, thanks


Please help!!!!!

Posted by Computerfreaks on February 11, 2002 3:43 AM

driving me mad

Re: Please help!!!!!

Posted by DK on February 11, 2002 4:55 AM

When the message 'This source contains no visible tables' I assume you are then presented with the Query Wizard dialog box. Click on Options and check the System Tables checkbox. Each of the worksheets in your database will now be shown as a table.

Let me know if it doesn't work,
D


Thanks!!!!!!!

Posted by Computerfreaks on February 11, 2002 5:05 AM
Works, thankyou

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.