<div>
Sorry, to make it clear, the Access table must be a duplicate of the excel table ie have the same number of columns with the same data in the cells.
</div>


Sorry, to make it clear, the Access table must be a duplicate of the excel table ie have the same number of columns with the same data in the cells.

selectExcel.mdb

<div>
Looks Great! The only thing is when I import your form in my own database, it opens in full page and not like a popup window (as it does in your sample db). How can it make it look the same?<br />
Thanks
</div>


Looks Great! The only thing is when I import your form in my own database, it opens in full page and not like a popup window (as it does in your sample db). How can it make it look the same?
Thanks

<div>
set the popup property to &nbsp;yes
</div>


<div>
Your code works, fine, but what is the reason when we are importing to a DB, the table has first line blank.
</div>


Your code works, fine, but what is the reason when we are importing to a DB, the table has first line blank.

<div>
<div class="content wysiwyg-content">
Hi! For my Access database, I am looking for a VBA code that would:<br />
- Open a windows dialog box and let the user select an excel file<br />
- create an empty table called &quot;Import&quot;<br />
- copy the content of the columns of the excel file into the column of the access &quot;Import&quot; table.<br />
Blank cells do not need to be imported, only the filled ones.<br />
Thanks!
</div>
</div>


Hi! For my Access database, I am looking for a VBA code that would:
- Open a windows dialog box and let the user select an excel file
- create an empty table called "Import"
- copy the content of the columns of the excel file into the column of the access "Import" table.
Blank cells do not need to be imported, only the filled ones.
Thanks!

VBA code to import excel table in 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.