How To Import Excel And Text Data In Access 2010


show more Importing Excel and text data provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training show less
please wait ...

Importing Excel and text data

One of the most efficient ways to bring data into your Access file is to import it from other programs. Access has the ability to import in several different formats. Two of the most common are Excel Spreadsheets and text, such as Comma Separated Values, or CSV. Let's create a new table based on an Excel file. Click on the External Data tab and then click Excel. A new window will appear, asking you to browse for your file. Click on Browse, go to our Chapter 11 files and double-click on Olive Cost.

Now you have the option of creating a brand-new table from scratch, adding the file's data to an already existing table, or linking the table. If you add the records to a current table, you will need to edit the Excel spreadsheet so that the file names are identical, the number of columns, the spelling, the spacing, everything. If you link to the table, you actually create a live connection between the two. Any changes made to your data, in either program, will be reflected in the other....

Importing Excel and text data
Video duration: 3m 39s 3h 30m Beginner

Viewers:

Importing Excel and text data provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training

please wait ...