<div>
you can use this command line<br />
<br />
docmd.transferspreadsheet acimport,8,&quot;Nameoftable&quot;,&quot;<wbr />c:\folder\<wbr />myXl.xls&quot;,<wbr />true,&quot;Name<wbr />OfRange&quot;
</div>


you can use this command line

docmd.transferspreadsheet acimport,8,"Nameoftable","c:\folder\myXl.xls",true,"NameOfRange"

Spreadsheettype-values.jpg

<div>
Thank you very much for the quick and detailed response!
</div>


Thank you very much for the quick and detailed response!

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I would be grateful if you could you please explain what VBA script I could use to import data from named ranges in an Excel workbook and append to existing tables in an Access database. &nbsp;Each range in the Excel workbook would correspond to a table in Access.<br />
<br />
I would need to perform this import on several Excel workbooks which would have different filenames.<br />
<br />
Thank you<br />
Alison
</div>
</div>


Hi,

I would be grateful if you could you please explain what VBA script I could use to import data from named ranges in an Excel workbook and append to existing tables in an Access database.  Each range in the Excel workbook would correspond to a table in Access.

I would need to perform this import on several Excel workbooks which would have different filenames.

Thank you
Alison

Import from named ranges in Excel workbook into Access and append to tables

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.