Importing multiple spread sheets

D

David

I have a variable number of excel files in a particular folder- while each
file has a different name- they all contain a sheet of a similar name.
Is there a function I can run to import these tables into one access table
 

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

Importinf multiple spreadsheets 3
Importing any excel files with any sheet name into different tables in MSAccess using code 0
Import 4 Different Excel Files from One Folder 0
Counting multiple memberships 1
Linking Spread Sheets 1
Excel, assign cells in multiple worksheets from one sheet 1
Data collection from multiple excel spread sheets 2
Access Importing csv daily files into access 2007 1

Top