need to import multiple excel files into 1 access database

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

Guest

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
 
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
 
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?
 
Back
Top