Hi mdmackillop - I had a quick look at your kb link last night and opened up the access file. Do I need to create this prior to exporting from excel? Also is VBA required to export from excel to access or is there an export facility which allows you to select the data from a sheet?

cheers,
rrenis