Topics Search

Copy paste multiple rows in a table

Copy paste multiple rows in a table
Views: 133
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:

More topics

 

How to copy and paste multiple rows multiple times

Preview
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

Preview
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

Preview
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.
 

Copy and paste multiple items by using the Office Clipboard

Preview
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

Preview
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
 

Inserting multiple lines to multiple rows

Preview
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.
 

Single Copy and Multiple paste operation:

Preview
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?
 

How to detect user pasting multiple rows into a datasheet

Preview
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?
 

Copy and paste multiple items by using the Office Clipboard

Preview
The Microsoft Office Clipboard allows you to copy up to 24 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.
 

Copy Paste function is not working when the application is running behide

Preview
I have created an application using visual studio 2008. The application is to copy the data from one excel file and paste to another excel file. The problem happen when I try use the copy paste function at the same time in other excel file.(I have opened others excel file before the application start.) I'm noticed the value that I paste is not same from what I copy in the excel file.(the application is running behind and using copy paste function at the same time.) How to hold the value using vb.net when copy from excel for the application so that othercopy paste function is not affect it? Or do you have any method to solve this issue? Kelen C