What is Back-End Data File (Access2002)

Topic

New Reply

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?

Reply | Quote

Replies

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.

Reply | Quote

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?

Reply | Quote

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…

Reply | Quote

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

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

Reply | Quote

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

Reply | Quote