Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Voyager

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Voyager
    3. Knowledge Articles
    4. Import an External Table using an Excel File into Voyager Prepackaged Access Reports

    Import an External Table using an Excel File into Voyager Prepackaged Access Reports

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    3. Additional Information
    • Product: Voyager
    • Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare

     

    Question

    How to manually import an Excel file into a new table in Prepackaged Access Reports?

    Answer

    These steps describe the process (basic steps) to manually import an Excel file into a new table in Access in order to use the Excel data as part of an Access query. 

    These instructions are informational and software changes in Access need to be taken into account when using them; the locations and options of the menu items may vary, but the general concepts provided here should be applicable.

    These instructions presume you have an Excel file ready for import.

    1. Open your Reports.MDB file (note it is important to make frequent backups of this file).
    2. Go to External Data > New Data Source > From File > Excel 
    3. Navigate to your Excel file.
    4. Make sure the "Import the source data into a new table in the current database" option is selected and click OK (this is the default).
    5. The Import Spreadsheet Wizard will open. 
    6. Click the box that says: "First Row Contains Column Headings" and click the Next button.
    7. If it appears, make sure the following screen has "In a New Table" selected and click the Next button (this is the default).
    8. Specify the information for each of the fields you are importing in the "Field Options" area. Typically you will want to set your Field Name correctly (e.g., "BIB_ID") and set the Data Type for record IDs to "Short Text". See first screenshot below.
    9. Make sure you have "Let Access add primary key" selected for your new table and click the Next button (this is the default).
    10. For "Import to Table" enter your table name (this is case sensitive, do not use blanks).
    11. Click the Finish button.
    12. Close the Wizard dialog box.
    13. Your new Table should now be available for use in queries using the (for example) "BIB_ID" field that you created.  See second screenshot below.

     

    clipboard_e0d52dcea0e8237956a538506d589de4b.png

    Step 8: Specify field information for the record ID column.  If you receive a "Type mismatch" error see: Receive the "Type mismatch in expression" error when running a query in Voyager Prepackaged Access Reports

     

    clipboard_efa2df29560a0a462831c989dab0cd7bf.png

    Step 13: Incorporate your new table in a query.

     

    Additional Information

    Constructing custom SQL queries by request and troubleshooting unexpected results from customer-created SQL queries falls outside the scope of Support. The above has been posted for informational purposes.  Voyager-L and Developer Network are useful resources for finding helpful custom SQL or obtaining assistance from peers in troubleshooting custom queries.

     

     


    • Article last edited: 21-Nov-2020
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Import a SQL query into Voyager Prepackaged Access Reports
      • Import queries from one Voyager prepackaged Access Reports.MDB file to a different prepackaged Access Reports.MDB file
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Voyager
    2. Tags
      This page has no tags.
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved