excel - Exporting an array of custom objects into Access table -

i have timesheet system in excel 3 rows (standard time, overtime, double time) each of our (100+) employees, , 1 column each cost code on site. ends being giant matrix, of empty. solution create employee datatype stores employee information , hours single cost code.

   public type employee      name string      trade(1 3) string      empnum long      comment string      addons(1 3) single      allowance(1 3) single      contract long      costcode long      sthours single      othours single      dthours single      workdate date    end type 

i can process spreadsheet , organize information in excel array of employee-type objects, i'm not familiar how export access, , questions relate exporting excel cells access. can put these objects cells on worksheet , way, seems there should better way.

currently best guess this:

insert data form excel access 2010 using vba

but i'd making 100+ updates table each export.

is there efficient way create table object in vba, populate array information, , append end of table in access in single update?

thanks.

-sean

the easiest way create table link in access. table links tables in rest of access, data stored externally. data inside access database, or inside sql server database, or have you.

in particular, data can in excel spreadsheet. define table in excel contains data in format that's right access application. build table link in access links table defined in excel.

when update excel table, updated results automatically appear next time reference table link in access.