Topics Search

Copy paste multiple rows in a table

Copy paste multiple rows in a table
Views: 158
I am trying to copy multiple rows (150+) and then paste them into the same table below the original 150 rows.

Can this be done? I can only seem to get 1 row at a time.
Sponsored Links:

Similar posts...

 

How to copy and paste multiple rows multiple times

How to copy and paste multiple rows multiple times Icon
I have a table of 5 fields and more than 5,000 records(rows). I need to copy all the rows and paste it 100 times in the new record row .

Could you help me how to do it? If Example:

ID Fld1 Fld2 Fld3 Fld4 Fld5

Now I need to copy all these 5000 records 100 times to make it like
ID Fld1 Fld2 Fld3 Fld4 Fld5

I think Access will automatically update the ID No's
 

Multiple record paste

Multiple record paste Icon
I'm sure this has been asked a hundred times, but I cannot find a good answer. In a table, I am trying to copy paste from one field, one record (cell), into multiple records of that same field or any field I wish. Basically, I would love to highlight any range, whether it is single or multiple records and rows, and paste over where I choose. So if in records 1, 2, and 3, I highlight and copy the values in field A, how do I paste these values in records 4, 5, and 6 of field A, B, etc. I know I'm thinking in Excel mode, but I generally do not manually input my data in Access, but rather dump reports through Monarch
 

Copy and Multiple Paste

Copy and Multiple Paste Icon
I would like to be able to copy a single record in a table and then paste this record a pre-defined number of times 10,20,30 depending on requirements. The reason I need to do this is that I want to set up a number of identical records that can easily be amended into unique records.

This will vastly reduce the amount of work and time spent entering records individually.

The only way that I have been able to achieve this is to copy and transfer the master record into Excel, and then copy the row and paste it into a range of cells. Copy the range of cellsback from Excel and then paste this range back into the Access table.
 

Inserting multiple lines to multiple rows

Inserting multiple lines to multiple rows Icon
I want to create an access form with a text box linked to a table. I want users to be able to copy cells from an excel column and paste them into the text box. I then want each row in the text box to be inserted into consecutive row of each table field.
 

Copy and paste multiple items by using the Office Clipboard

Copy and paste multiple items by using the Office Clipboard Icon
The Microsoft Office Clipboard allows you to copy multiple text and graphical items from Office documents or other programs and paste them into another Office document. For example, you can copy text from an e-mail message, data from a workbook or datasheet, and a graphic from a presentation and then paste them all into a document. By using the Office Clipboard, you can arrange the copied items the way that you want in the document.
What do you want to do?
* Learn more about how the Office Clipboard works
* Turn on the Office Clipboard
* Control how the Office Clipboard is displayed
* Turn off the Office Clipboard
* Copy multiple items to the Office Clipboard
* Paste items
* Delete items from the Office Clipboard
 

copy/paste in form - datasheet view

copy/paste in form - datasheet view Icon
I would like to make it possible for people using my database to copy paste 10 rows from excel table in to form in datasheet view. So far it works fine when I open it with shift+enter, but as soon as I open it in user mode, through one of the forms, it is not possible. Hopefully someone can help me with my problem
 

How to detect user pasting multiple rows into a datasheet

How to detect user pasting multiple rows into a datasheet Icon
I have a datasheet application that updates additional fields based on the input of one field using VBA code. Due to the design constraints, I use the following technique.

1. After the field is updated, I do a Refresh to save the row
2. Then I retrieve the other values I need using VBA code and save them.
3. Finally, I read the saved row, update the additional fields, and update the row.

This works fine as long as the operator enters the new row manually or even if he/she does a copy & paste of one row. However, if he/she copies and pastes multiple rows, then the Refresh doesn't insert the multiple rows and my step 3 above fails. Is there a way I can detect that multiple rows are being inserted so I can handle the event accordingly?
 

Single Copy and Multiple paste operation:

Single Copy and Multiple paste operation: Icon
I observed that when I copy a value, select a range of columns and try to copy in the entire range of cells, the value is pasted only in the beginning cell and rest all are empty.

But I have a requirement when after selecting the range of cells in the table and press Ctl+V the user should be able to paste the values in all the selected range of cells as in excel.

Is there a setting or something in Access for this functionality?
 

Three ways to programmatically duplicate a table in MS Access by VBA

Three ways to programmatically duplicate a table in MS Access by VBA Icon
Duplicating a table in Access manually is extremely easy - just Copy and then Paste the table object. The three screenshots below copy Products table, and then paste it to make a new table Products_Copy.
 

Copy Paste multiple records

Copy Paste multiple records Icon
I have a module that copies a record then pastes into a listbox, is there a way to copy and paste multiple records or can I do it by pasting the second record by inserting a new line at the end of the used listbox