Export Selected Cells From Excel to Selected Fields in Access

[fanzak]

Hi Everyone,
I am wondering if it is possible to export selected cells from excel to selected fields in a given table in access, with conditions. Lets say, copy the month budgets (from jan to dec) from year 2010. In excel we have the year, and in access we have field with years.



Any thoughts?

[NTC]

from the Access perspective; you would import the excel data into a temp table.

then you would develop an UpdateQuery that would apply the data in the temp table to the final table presuming there is a consistent logical crossreferencing join field.

these multiple events could be triggered to occur in a sequence in a macro or with vba.