Copy from clipboard

[luca]

Hi,
I have a table form from wich I paste data in from an excel. Everything works, I add a blank record and select it, then hit the paste botton and all the new records are added.

I wana write code that will add the new record, select it, and paste all in one shot.

Any ideas?

 

[Travis]

Try using the Import Features of Access. It works great with Excel. See TransferSpreadsheet for more details.