Markonni wrote:
There is simpler way to do this. You can make a link from
Access/tables view
to the Excel file.

The OP posted in .excel.programming then said, "i'd like to do it
programatically", so how about posting some *Excel code* to create the
linked table. Your approach is only simpler if operating on the same
Excel file each time.

Jamie.

--