need to import multiple excel files into 1 access database

S

Stressed

ok im code stupid, im very fluent with office, but when it comes to code im
retarded so is there any hope for me? i have over 300 files to import into 1
database but i dont want to spend my entire week doing it...... please
help!!!!


p.s. i did search but all i could come up with is code solutions
 
M

Mauricio Silva

can you give more details?
- All files have the same structure?
- Does the data goes to the same table?
- Are the files spread in your HD or in one folder?

Did you try linking the files as tables and creating a query to copy the data?

Mauricio Silva
 
S

Stressed

yes all files have same structure
yes just one table in one database
yes just one folder
yes i tried linking but for some reason it seems to have left off some of
the data from the xls spread?
 

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

Merging from an Excel file with graphics 1
import fields from multiple excel files... 5
importing multiple worksheets from excel to access 1
Search and consolidate multiple values in multiple fields 2
import multiple excel files **code stupid** 2
Convert Excel sprdsht with data in checked boxes to Access databas 1
Problem Importing Specific Worksheet From Workbook 6
how to import multiple Excel files into multiple Access tables? 9

Top