MoonPoint Support Logo

 

Shop Amazon Warehouse Deals - Deep Discounts on Open-box and Used ProductsAmazon Warehouse Deals



Advanced Search
August
Sun Mon Tue Wed Thu Fri Sat
           
17
         
2009
Months
Aug


Mon, Aug 17, 2009 10:04 am

Importing Data from an Access Database in Microsoft Excel

You can import data from a Microsoft Access database in Microsoft Excel 2007, even if you don't have Microsoft Access on the system. To do so, take the steps below:
  1. Open Excel.
  2. Create a new blank workbook or open an existing one that you wish to use.
  3. Click on Data.
  4. Select Import External Data.
  5. Select Import Data.
  6. Browse to the location of the Access .mdb file
  7. You will then be prompted to select the table in the Access database that you wish to import into an Excel spreadsheet. Select the table you wish to use by clicking on it and then clicking on OK.
  8. An Import Data window will open asking you where you wish to place the data in the Excel spreadsheet. The default location will be column A row 1. If that is where you want the data to go, click on OK, otherwise specify the location you wish to use.

    Import Data

References:

  1. Import Microsoft Access Data Into Excel
    Mysticgeek's Realm :: Your Guide Through the Cyber Galaxy!

[/os/windows/office/excel] permanent link

Valid HTML 4.01 Transitional

Privacy Policy   Contact

Blosxom logo