• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 6. Organizing Your Data > Integrating Other Data into Excel

Integrating Other Data into Excel

Often when you create a new database to organize your data, you find that the data already exists in electronic form and doesn’t have to be manually reentered. It might be on a mainframe computer, in an Oracle database, in a proprietary finance and accounting system, or in an older, PC-based database such as dBase or rBase. The trick is getting the old data into the new system as effortlessly and as accurately as possible.

If your database needs are complex enough that you are using an Access solution, you will probably have the database designer import the data when the application is created. More frequently, however, you will need to import a simple data table such as an employee list and will usually import it into Excel so you can analyze it further.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint