Need Macro for copy part of excel sheet rows and columns and paste in other file

[preethi3290]

Let me clearly Explain my situation,
I have a main folder in that there are 25 sub folders. In each sub folder daily I will update one excel sheet. I want to import the part of data to Access from each excel sheet.
For example I have entered one excel sheet in each sub folder today.
So there will be total 25 excel sheets from all sub folders.
I want to import these excel sheets data to Access.
In my excel sheet the table starts from A15.

 

[SirJB7]

Hi, preethi3290!
For the Access tables, primary key, foreign keys or any other constrain or relation?
Regards!

 

[preethi3290]

No,i don't have any constrain. But my excel table is middle of excel sheet. That is the reason I am unable to import into access

 

[SirJB7]

Hi, preethi3290!
What do you mean by middle? Could you please elaborate?
Regards!

 

[preethi3290]

Middle means the table which I want to extract data is not at the start of excel sheet. It starts from A15