Pasting data from Excel to Access

[ejstefl]

Hello,

I'd like an easy way for my users to be able to transfer data from Excel to Access. Basically, I'd like them to manually create a new parent record, and paste into an empty text box new child records. Then, when they clicked finish, I'd grab the info in the text box and put it in the appropriate tables. The trouble is - I have no clue how to do this. If someone could tell me how to get data pasted into a textbox into a table, I could figure the rest out. Any advice?

Thanks,
Eric

 

[ejstefl]

Does anyone have any idea how to do this? Or, is there another way I should be looking at doing this?