Copy paste multiple rows in a table

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:

Related Topics

How to copy and paste multiple rows multiple times
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
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
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
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
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
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:
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
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 Paste function is not working when the application is running behide
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


Copy Paste multiple records
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


Copy query
In the past, I can copy any existing query and paste as a copy so I can modify based on the old one for a new query. Suddenly I can copy the query but cannot paste into query group as the paste feature becomes grey (not available). What did I do causing paste feature disable?


Failure to make a copy of existing query
In the past, I can copy any existing query and paste as a new copy so I can modify based on the old one for new query. Suddenly I can select copy but the paste becomes grey (not available).What did I do something wrong causing the paste feature disable?


Display copy and past friendly report results
Is it possible to display a report with multiple fields in one text box. the reason I ask is I want to be able to copy and paste multiple fields as one block of text? the reason I need this is am building a database for client testimonials, and want to generate a block of text that somebody can just copy and paste, that contains the client name, date and referral all in oneblock. Currently it keeps all the components in separate boxes.


Copy and Paste Data Into an Indexed Table
We have created a split database which allows my manager to update the data in the table on a weekly basis. The table is indexed in order to speed up time it takes to search for the records from the front end.

Every week we have to add records to the access table from an excel spreadsheet. My manager likes to copy and paste the new records into the existing table. If we continue to add records to the indexed table via copy and paste, will the table automatically stay indexed or will this slow the response time down.


Copy and Paste Data Into an Indexed Table
We have created a split database which allows my manager to update the data in the table on a weekly basis. The table is indexed in order to speed up time it takes to search for the records from the front end. Every week we have to add records to the access table from an excel spreadsheet. My manager likes to copy and paste the new records into the existing table. If we continue to add records to the indexed table via copy and paste, will the table automatically stay indexed or will this slow the response time down.


Display copy and past friendly report results
Is it possible to display a report with multiple fields in one text box. the reason I ask is I want to be able to copy and paste multiple fields as one block of text? the reason I need this is am building a database for client testimonials, and want to generate a block of text that somebody can just copy and paste, that contains the client name, date and referral all in one block. Currently it keeps all the components in separate boxes


Cut multiple rows into new spreadsheet based on cell values
I'm new with macros and am trying to cut rows from sheet2 to a new sheet based on the values in column a. In Column A there are numbers (1-however many.sometimes 5 sometimes 80) and I want each number to be on its own tab (there are five columns of information for each row.not sure if that matters or not). Each number may have multiple rows associated with it so I would like to cut all those rows and paste them into a new sheet


Paste Append not working
I've recently been forced to migrate to Access 2007 (much prefer 2003 unlike Excel and Word!)

I've got a problem with locking down a database and creating a custom toolbar to Paste Append records. The aim is that the user should be able to manually select and copy records from one table to another via the clipboard. When I add Paste Append it is disabled. When I use Paste, it creates a brand new table and pastes all the records in there rather than the one selected. (Also the user isn't even allowed to see the new table as I have intentionally hidden all extraneous windows and functionality). So.at present, I've had to leave the users with instructions to use Ctrl-C and Ctrl-V and remove all ribbons and toolbars, which is less than ideal for many users. I want my cut, copy, paste and paste append


Copy & Paste ACCESS Report Design
I need several Reports which are very similar to each other. I have designed the first Report. Now I want to know how I can copy & paste the first Report so that I can generate several other identical Reports.

Then I plan to perform some minimal chages to the copied Report design. Do I copy/paste the Report itself, or do I copy/paste the Report design?


paste a table into a cell
Im trying to copy many tables from a website and paste each one of them as a single piece of information in my database table, each table for each cell,

Ive tried the simply copy and paste in a cell with format Memo and the format of the table is lost, I know that I can make it an image and attach it to each cell but that will make my database huge and slow