How do I find the source table (in Access database) used by MS Qu.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I find the source table (in Access database) used by MS Query. I know
it must be somewhere but am not a heavy user of MSQ.
 
hi,
open the MSQ in design mode.
Data>get external data>edit query.
if the query wizard comes up, go to sheet 4 and click
view data or edit query in microsoft query.
in the MSQ dising mode...
go view>SQL
This is the SQL statement behind the query. the table
will be named there.
Regards
Frank
 
You must log in or register to reply here.

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

How to export table from outlook into ms access table? 0
MS word Find and Replace using Regex - Help required 0
How do I invoice a cost to a custom built MS Access Accounting Database? 0
Edit Existing Code 2
Access Table Import with VBA 1
Auto refresh linked excel table from access database 1
Can't create a report from my query in Access 1
How to change Pivot Table external data source (MS Access Database)by VBA 0

Back
Top