importing non-contiguous ranges from excel to access

[J. Lowe]

I need a VBA solution.

I have a group of excel file with data that I'd like to
import into access. The data to be imported is not
contiguous. For example I want to import data from columns
1, 3, 5 and 6 into the same table. The column headings in
excel also do not relate to the columns in the access
table. (This is by design.)

What I need to be able to do is read the data from column
1 and specify the field to import the data to. So if I
have an excel spreadsheet with 5 rows, I need to import
all rows in column 1 to the first field of 5 records in
the access table. I then need to import all rows in column
3 to the second field of the existing 5 records and so on
and so forth.

Is there a way for me to do this, ie. import data field by
field, column by column?

Thanks.