Archive of Mr Excel Message Board
Back to General Excel archive index
Back to archive home
Data TrackingPosted 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,
Thanks!!!!!!!Posted by Computerfreaks on February 11, 2002 5:05 AM
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.