<div>
The name of the worksheets in each MS-Excel workbook, &amp;&nbsp;their individual layout, plus the definition/order of the columns within the [tbl_all] table would be useful.<br />
<br />
A sample MS-Excel workbook (if they are all the same, or noting differences, if applicable), &amp;&nbsp;an MS-Access database containing a blank table definition, may also help &quot;Experts&quot; engage with your question.
</div>


The name of the worksheets in each MS-Excel workbook, & their individual layout, plus the definition/order of the columns within the [tbl_all] table would be useful.

A sample MS-Excel workbook (if they are all the same, or noting differences, if applicable), & an MS-Access database containing a blank table definition, may also help "Experts" engage with your question.

<div>
That should be:<br />
<br />
sFile = Dir(&quot;Path to the folder\*.xls&quot;)
</div>


That should be:

sFile = Dir("Path to the folder\*.xls")

<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
I would like to carry out a routine which imports a number of Excel Files which are held in my Folder (C:\lists) into my Access 2003 programme. All the Excel Files would be appended into the same Table (tbl_all) within my A03 programme.<br />
<br />
Grateful if someone would provide me with the vba code to carry out this task at a touch of a button.<br />
<br />
Please let me know if my request requires clarification.
</div>
</div>


Hi All,

I would like to carry out a routine which imports a number of Excel Files which are held in my Folder (C:\lists) into my Access 2003 programme. All the Excel Files would be appended into the same Table (tbl_all) within my A03 programme.

Grateful if someone would provide me with the vba code to carry out this task at a touch of a button.

Please let me know if my request requires clarification.

Routine to import

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.

Microsoft Access

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.