<div>
Thanks a lot. It works !!<br />
One more little question. Is it possible to not import the hidden sheets?<br />
<br />
Many thanks.<br />
Stone
</div>


Thanks a lot. It works !!
One more little question. Is it possible to not import the hidden sheets?

Many thanks.
Stone

<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
I need your help. I have a folder (D:/data) which contains many excel files with the diffrence names and each excel file has many sheets with the differet name also. What I want is I would like to import the sheets from these excels files to tables in Access.<br />
<br />
Meaning, if my sheet name China, my table in access will be named as Table_China as well as if my sheet name is USA, my table will be names as Table_USA.<br />
<br />
And once the importing is finished, all the excel files will be moved to another folder (D:/data/done)<br />
<br />
Thank you very much in advance for helping me,<br />
<br />
Best regards,<br />
Stone
</div>
</div>


Dear Experts,

I need your help. I have a folder (D:/data) which contains many excel files with the diffrence names and each excel file has many sheets with the differet name also. What I want is I would like to import the sheets from these excels files to tables in Access.

Meaning, if my sheet name China, my table in access will be named as Table_China as well as if my sheet name is USA, my table will be names as Table_USA.

And once the importing is finished, all the excel files will be moved to another folder (D:/data/done)

Thank you very much in advance for helping me,

Best regards,
Stone

Importing excel files with many sheets to Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.