Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Texas, USA
    Posts
    374
    Thanks
    1
    Thanked 0 Times in 0 Posts

    What is Back-End Data File (Access2002)

    I have an Access2002 accounting software. To import data to several tables in its data file, the publisher told me to open the back-end data file to use the native import function for Microsoft Access. What does this Back-End data file mean?

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: What is Back-End Data File (Access2002)

    The back end is where the tables are

    The front end is that 'database' that links to the back end tables, and contains the queries, forms, reports, and code.

    the database splitter produces, from A.mdb, two new files: a modified A.mdb as the front end, and A_be.mdb as the back end. Your publisher is referring to this '_be' piece.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: What is Back-End Data File (Access2002)

    This assumes the database has been split into two .mdb files; one .mdb file that contains the tables and another .mdb file that contains the queries, forms, reports, macros, modules, and shortcuts to data access pages. The back-end is the one that contains the tables where your data is stored. The other is called the front end.
    HTH

  4. #4
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Texas, USA
    Posts
    374
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: What is Back-End Data File (Access2002)

    It explains all. Thank you very much.

    My next question is how to do an import:

    I need to import the data from an Excel2002 file,
    called VENDOR.xls located at C:My Documents
    to a table,
    called TBLVENDOR.

    According to the publisher, I need to create an append query to append the records from the imported VENDOR.xls table to the TBLVENDOR table. How to create this append query?

  5. #5
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: What is Back-End Data File (Access2002)

    After carefully backing everything up...

    I would try the easy way: double-click the backend to launch axp. On the filemenu click Get External Data | Import and follow the wizard...

  6. #6
    New Lounger
    Join Date
    Mar 2002
    Location
    Sydney, Australia
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: What is Back-End Data File (Access2002)

    If you need to program this (if it has to be done regularly) try:

    DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tbl_name", ("Filename.xls"), True

Posting Permissions

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