automatic import data from excel into access

[arcootje]

i want to make a macro or module to import data automatic from excel in access, but i only want to import the non empty rows

 

[Joe4]

If you want to do it via a macro, check out the TransferSpreadsheet command.

If you are importing into an exisiting table that already has a primary key set-up, I don't think it will import blank rows.