multiple tables-same query

J

Jean

I have 40+ tables that are identical format, different
data, they are linked to excel spreadsheets. Is there any
way to create a query that will prompt for the name of the
file, so I don't have to create 40+ queries?
 

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

Address Format changed after Migration 0
Embed the same Excel multiple times 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Crating User Form to Add Names 1
Creating a Chart on form from selected data in query. 0
Adding data to MS Access from csv file 0
Excel - Wich Function should I use? 1
How to have two tables on same line? 1

Top