Is to possible to import multiple excel files in one table

[BizBoy]

Hi,

I have 5 excel files. All files have same structure.
These files are prepared on daily basis.

So, structure for 9-Apr-2018 and 10-Apr-2018 will be the same.
Only difference will be between number of records each file.

How to I import all these 5 excel files in one single table of access.
For example, combine records in 5 files are 500.
And records in access after importing will be 500.

Can anyone please help me in this.

 

[Joe4]

It doesn't really matter if you are importing 1 or 5. You can import Excel files in existing Access tables.
If they all have the same structure, and their header matches the field names in Access, it should be quite easy.

 

[BizBoy]

Hi Joe,

I will try again. If unsuccessful, will post exact steps followed by me.
Thanks for the help. Have a nice day ahead.