Importing excel files to access by pressing the button

[amateur12]

Hello all,

I have to write a vba code running by clicking on the button that will open the window where we choose the excel files (8 excel files) that we want to import. Is it possible to define in the code which columns I want to import (cause I don't need all of the data)?
I've been trying many codes but none of them was working.
Or maybe there is a better way then writing code in VBA?
To be fair it's my first task with access so I'm not familiar with it.

Greetings,
Estebian

 

[Joe4]

Welcome to the Board!

One option would be to import them into a temporary table that has all the fields. Then you can use an Append Query to write them from the Temporary Table to your Final Table, only writing the fields that you want.