Using Excel VBA to append data to Ms.Access Table

Hi jadhavabhay,

It sounds like you want to write some VBA code in Access that imports a range in Excel..??

A better method might be to line your Access to an Excel workbook. This way any data added (appended) to the Excel would show up in Access.

I'd suggest you add all your data to a single sheet in Excel and then create a link to that sheet from Access.