Bulk Add Blank Records in Access 2013
Posted on 2015-02-01
Is there a easy way that I can add several new records in a access table? Or several new records with a generic letter in the first field?
What I have to do is copy several cells of data from a excel spread sheet into specific fields in a table. Usually about 700 cell at a time. What I have been doing is simply hitting the down arrow key and typing a "a" so it will create a blank new record so I have the room to paste the data as needed.
What I am trying to do is see if there is a easier way to get those blanks records so I can paste the data.
The excel sheet I am using is not in the same order as the table so I have to take a few columns of data from excel and paste it in a different order in the Access spreadsheet.