Import data from an Excel file, storing it in a temporary Access table

[VenusInBlueJeans]

Hi guys!

Im a newbie at Access and I am trying to do the following:

1) From my Access Form, I want to press a button "Load data"

2) Then I want a window to appear (API) so I can browse through my computer and select an arbitrary .xls file

3) The .xls file has a sheet with 3 columns, and I want those columns imported to a temporary (existing) Access table

Is that possible? Please help me!

Thx
/M

 

[JonoB]

First, and most importantly, read this :
FAQ181-2886


Then read this:
thread705-566460