Solved: Add data to a closed workbook

[phendrena]

Hi Kenneth,

Many thanks for the detailed advice, i have a question...

The first step is to click the Tools menu in the VBE and set the reference to Microsoft ActiveX Data Objects 2.8 Library. This is the ADO reference.

The version of this that i can see with excel '97 etc is 2.7, is this going to make a massive difference to the above code as i've tried using it, and nothing gets passed to Access (directly copied and pasted - although i have changed the field names in the vba and also the database to include '_' and removed the '?').

Thanks,

EDIT : It did copy the data, when i originally created the database it included a lot of blank rows that i didn't delete, so i forgot to look at the end of the database....