VBA code to import excel table in Access

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!
Jean-Christophe GALLANDKorea R&D DirectorAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
try this sample db
selectExcel.mdb
0
 
Jean-Christophe GALLANDKorea R&D DirectorAuthor Commented:
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.
0
 
Jean-Christophe GALLANDKorea R&D DirectorAuthor Commented:
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
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
Rey Obrero (Capricorn1)Commented:
set the popup property to  yes
0
 
Jean-Christophe GALLANDKorea R&D DirectorAuthor Commented:
Great, as always...
0
 
gfrancoCommented:
Your code works, fine, but what is the reason when we are importing to a DB, the table has first line blank.
0
All Courses

From novice to tech pro — start learning today.