Saving imports and exports for reuse


show more Saving imports and exports for reuse provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts show less
please wait ...

Saving imports and exports for reuse

If you move data in or out of your database on a regular basis you don't need to go through all the import and export steps every time. For example, if you receive data weekly from your company's larger database system, but you use Access for your day -to-day analysis, those weekly imports will always have the same settings. So you can expedite the process by saving your setup steps for reuse. Let's say for example every Monday I receive an Excel spreadsheet of new products from corporate, and I need to add them to my database to start the week. So I'll add these two new brands to my existing product's table.

I'll close my spreadsheet in Excel. Here is what my table looks like in Access. I'll close this as well. Go to your External Data tab and click on the Excel button. First, we need to navigate to our file. So I'll click on Browse and find the Productsimport file. Next, I have the option of creating a brand-new table from scratch, adding the file's data...

Saving imports and exports for reuse
Video duration: 4m 47s 3h 43m Intermediate

Viewers:

Saving imports and exports for reuse provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts

Subject:
Business
Software:
Access
Author:
please wait ...