VBA Macro to Paste From Clipboard to Table

[kdbailey]

I've been trying to figure out a way for my associates to be able to copy "Model Numbers" from either excel or another access table and be able to click a button that will import the clipboard into the necessary table to run specific data.



Basically the clipboard will hold a single column of X rows of "Model Numbers". I'm looking for a macro that will take those records and paste them into [My Table].[Model Number]. Anybody have any ideas?

[Micron]

Would you be better off just linking the Excel spreadsheet (like a table) without having to move stuff around? If not, the operation to paste data into a table is on the Ribbon (Paste Append). If you're looking to do this with a macro, turn on 'show all actions' on the ribbon and look at the command list for the action "RunCommand". I 99.9% never use macros, so that's about all I can offer.

[kdbailey]

The issue is that my colleagues could get their list of models from anywhere, and I'd prefer them not going into the background files (as other things will be happening when they are pasting into the table); they would likely miss things and would run into errors.

I did discover the paste append command, and is the current method I'm using.

If anybody else has any other ideas, please let me know.

[kdbailey]

How do you paste append to a specific field within a table?

[Micron]

You can't. I guess I assumed the target table only had one field because of the 'single column' part. Sorry.