Excel VBA code to copy specific records from one access table to another - Object Required

[DannyJ]

I have an access database that receives information from an excel userform. I then have another excel spreadsheet that pulls the data back from access depending on search criteria. What I would like to have is a macro that starts when certain cells are clicked which will move the record from 'TABLE1' to 'TABLE2' in access.

The code I came up with is attached in an excel spreadsheet as my firewall is blocking all SQL injections apparently?

Thanks in advance,

Danny

[DannyJ]

Is this doable? I have still been persevering with it and don't seem to be getting anywhere.

Any help much appreciated

[cytop]

Your basic SQL statement is probably wrong

Lose the '*' after 'Table2' and retry.

No data, no database so no testing, just an observation.

[DannyJ]

Thanks Cytop, I have removed that and am still getting the error.

I thought that * would need to be there to tell it to take all fields?

Danny