Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Unanswered: Database of Excel file

    I have an excel file (only 2 pages) containing formulas for calculations from input of data. I like to make an access database out of it, so that it can be viewed and used in a more efficiant way with reports etc.. But, I have no idea how to do this.
    In a databse such as access it is a more userfriendly layout which I like to achieve. Can somebody help me? I can send the excel file as attachment if somebody likes to help me. This is probalby very easy for anyone who knows access or similar programs.....

  2. #2
    Join Date
    Jan 2004
    Aberdeen, Scotland

    To use your excel workbook in Access all you have to do is Link the workbook to Access.

    To Do this

    Open Access Database choose get external data Link Tables choose files of type Microsoft Excel and follow the wizard through to completion
    You will need to do a similar Link for each Excel Sheet.
    Your Excel Sheets can now be used as database tables

    Hope this Helps

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts