how to one copy and multiple cells paste in ms access

Question

how to one copy and multiple cells paste in ms access

For example in ms excel use ctrl + d

but not working in ms access

I want to paste a data somewhere in all the columns

Tell me how to do it on your behalf. how to paste multiple data

Answer 1

1. Users should NOT copy and paste data in this way. In other words, copying a group of rows and columns from a table, or from a spreadsheet, is an ineffective, inefficient way to import data.
2. Access is a tool used to create relational database applications. Tables follow the rules of normalization. They are not the equivalent of an Excel worksheet. Don't try to use Access in the same way you would use an Excel spreadsheet.
3. Access relational database applications consist of THREE components.
   1. Tables which store data. Users should not be able to open tables directly for any reason.
   2. Interface objects through which users interact with the data. These are the forms and reports in your relational database application.
   3. Code which runs the entire relational database application. This is the VBA and Macros you create for this purpose.

You want to copy chunks of data from "somewhere" and paste them into a table. This is actually possible, but very, very undesirable. It is difficult to get it done correctly if it can be done at all.

If you are copying records from one table to another table, use an append query. Append queries are designed specifically for that purpose and do it really well.

If you are importing data from an external source (another accdb or an Excel file), the most effective way to do that is link to the data source and, again, use an append query.

Answer 2

We can't explain anything unless we understand what you don't understand. Do you not understand the difference between a spreadsheet abnd a database? Do you not understand the realtional database model?

We want to help but specific questions help us help you.

Answer 3

What do you not understand?

You should Google the subject of creating queries, Insert queries, Update queries, ...

Ms access table spreadsheet in data some copy one time and paste multiple column

Answer 4

What did you not understand about Access NOT being a spreadsheet. As I said, a table is not rows and columns, its records and fields. The data positions are not fixed like in a spreadsheet so you CANNOT copy and paste blocks of data across records.