I am attempting to import over 300 excel files into 1 access database. Is this possible.
Any and all help is greatly appreciated.
I am attempting to import over 300 excel files into 1 access database. Is this possible.
Any and all help is greatly appreciated.
wasofolde, yes it is possible, but it would help if they were in one folder.
Is the Format and structure of each Excel Workbook exactly the same?
Do you want the data to go in to one table?
Is the table already "prepared" with the correct formats and data types etc?
Yes, all of the excel sheets are in one folder, and they are all in the same format. They also have all the same headers if that helps.
I have prepared a table for them to be imported to as well.
Thank you for all your help
waysofolde, the code that I normally use Imports the Excel Sheet, stores the data in a Temporary Table (cunningly called tbl_Temp), transfers the data using Append Query and then deletes or clears the temporary table.
For me to help you I would need a copy of one of your Excel Sheets, it doesn't need any real data in, but any headings and a dummy record would be very useful.
Also a copy of the database with the "Blank" table that will ultimately receive the data.
I also need the exact "Path" to the folder with the Excel Sheets in it.
Solved.
Thanks to OBP for all your help. It is greatly appreciated.