Excel 2010 provides the capability to exchange data with other applications.

Business & Finance
Tutor: None Selected Time limit: 1 Day

Excel 2010 provides the capability to exchange data with other applications.  Discuss the different types of ways to exchange data between Excel and other Microsoft applications.  Are there limitations to the exchange process?  How can you exchange data with other applications that are not part of the Microsoft Office Suite?  Discuss how you would exchange data with external data sources such as websites.

Mar 23rd, 2015

Data formats that Access can import or export is to open a database and then explore the External Data tab on the ribbon.

1. The Import & Link group displays icons for the data formats that Access can import from or link to.

2. The Export group displays icons for all the formats that Access can export data to.

3. In each group, you can click More to see more formats that Access can work with.

If you don’t see the exact program or data type that you need, chances are your data can be exported by the other program into a format that Access understands.

Limitations: There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.

One of the most useful features of Access is its ability to interface with data from many other programs. In fact, it’s difficult to summarize in a single article all the ways in which you can move data into and out of Access. For example, here are just a few ways in which you might use the data-exchange features of Access:

  • To combine data that was created in other programs.

  • To transfer data between two other programs.

  • To accumulate and store data over the long term, occasionally exporting data to other programs such as Excel for analysis.

Overview of external data operations in Access

In many programs, you use the Save As command to save a document in another format, so that you can open it in another program. In Access, however, the Save As command is not used in the same way. You can save Access objects as other Access objects, and you can save Access databases as earlier versions of Access databases, but you cannot save an Access database as, say, a spreadsheet file. Likewise, you cannot save a spreadsheet file as an Access file (.accdb). Instead, you use the commands on the External Data tab in Access to import or export data between other file formats.

NOTE   You can also write macros or Visual Basic for Applications (VBA) code to automate the import and export operations that are available on the External Data tab.

Export data to another format

The general process for exporting data from Access is as follows:

  1. Open the database that you want to export data from.

  2. In the Navigation Pane, select the object that you want to export the data from. You can export data from table, query, form, and report objects, although not all export options are available for all object types.

  3. On the External Data tab, click the type of data that you want to export to. For example, to export data in a format that can be opened by Microsoft Excel, click Excel.

     In most cases, Access starts the Export wizard. In the wizard, you may be asked for information such as the destination file name and format, whether to include formatting and layout, which records to export, and so on.

  4. On the last page of the wizard, Access usually asks you if you want to save the details of the export operation. If you think you will need to perform the same operation on a recurring basis, select the Save export stepscheck box, fill in the information, and then click Close. Then, you can click Saved Exports on theExternal Data tab to re-run the operation.


Mar 23rd, 2015

Studypool's Notebank makes it easy to buy and sell old notes, study guides, reviews, etc.
Click to visit
The Notebank
...
Mar 23rd, 2015
...
Mar 23rd, 2015
Dec 11th, 2016
check_circle
Mark as Final Answer
check_circle
Unmark as Final Answer
check_circle
Final Answer

Secure Information

Content will be erased after question is completed.

check_circle
Final Answer