How to Copy data from Excel in Access - Install Office 365 [ Office.com/setup365 ]

move it into access so you can take advantage of its querying and reporting features one way is to just copy and paste the Excel data into access either into an existing table or into a new one here's how to do it you might need to do some cleanup in Excel first access tables require that you structure your data which helps keep things more accurate make sure all the data in each column is of the same type such as text dates or numbers get rid of any subheadings summary rows or blank rows you can recreate those later using the grouping and totaling features of Access queries and reports if you're going to be pasting the data into an existing access table make sure your Excel data has the same number of columns as the Access table and that the columns are in the same order you might need to add a blank column here and there in your Excel worksheet to make them match up if you're creating a new table in Access just format the Excel worksheet the way you think is most useful for example it's a good idea to separate first and last names into separate columns and address information is usually more useful if you separate it into columns as well after your data is ready select it and copy it to the clipboard if you're creating a new table with this data in access just right click in the navigation pane and select paste if your copied data includes the column headings select yes otherwise select no access creates a new table and you can now start working with it if you're pasting into an existing table in Access double-click the table you're adding to select the asterisk in the empty row at the bottom to highlight the new row and then on the Home tab select the down arrow under paste and then select paste append the paste operation might take a couple of tries if your excel data doesn't match up with the columns in your access table if you're having trouble pasting double-check the data types of each column in the access table you can do this by selecting the fields tab and then clicking in a column that columns data type is shown here make sure the data you're trying to paste into that column matches that data type after you paste the data you can start working with it in Access because this is a copy of the data your original data in Excel remains unchanged [Music]

Channel: Microsoft Office 365

Views: 135

Rating: 5 out of 5

Keywords: Microsoft Office, Microsoft Office 365 Setup, MS Office, MS Office 365, office setup, office 365 setup, office setup installation, https://msoffice-set-up.com, http://msoffice.com/setup, Access

Id: ma-ombVkPRw

Length: 3min 20sec (200 seconds)

Published: Tue Aug 18 2020