Microsoft Office Tutorials and References
In Depth Information
Creating a QueryTable for Access
The Select Table dialog box will appear, so all you need to do is click to select the name of the table,
and then click the OK button as shown in Figure 23-5. After that, the Import dialog box will
appear. I chose to keep the imported table as a Table format, placed onto my worksheet, starting in
cell A1 as shown in Figure 23-6. Your Access table will load onto your worksheet as shown in
Figure 23-7, with the top row having AutoFilter buttons to help you with your future searches.
The Select Table dialog box may contain tables and queries, and you can import
data from either of them. You might want to be aware that Parameter queries
will not appear in this dialog box.