Hello all ,
I have about 50 excel workbooks and each of these work books has about 20-25 spreadsheets. I am creating a database and i need to transfer all those data in access. I made a sample workbook for you guys. Plus i have the macro code in it as well. When i run the macro, for the 1st spreadsheets it runs fine. When it goes to the next spreadsheets, its over lapping previous date field with the current date field. I need some help with that.

Here is the workbook and it has the macro code in it too. If you run the macro you will easily see what i am talking about.

Thanks in advance!

sample.zip