Table of Contents

How to Access QuickBooks Database?

Nowtoday with the assistance of the steps described below you will now be able to access QuickBooks Database.

12 Steps to Access QuickBooks Database Easily

Follow the steps below in an organized manner.

  1. First of all, open your computer and then “Download and install QuickBooks“.
  2. Make a Table in Microsoft access is result of numerous users. It will enable you as user to employ your QuickBooks Data files within same session as access database.
  3. Click on the option in File and next click on New“.
  4. Choose the Blank Database and next click on OK” button.
  5. Default database file name db 1 come in the box. Then you can “Edit and since it is more relevantly named e.g. – QB link.mdb.”
  6. Save the file as type: – “Microsoft Access Database“.
  7. Click on Create and then on NEW” Button.
  8. Select link table click on “OL“.
  9. Alter the First of type list to the ODBC database settings.
  10. Then choose the QuickBooks related database service name (Customer) you established with the ODBC driver.
  11. These can be one of us our pre-installed database service names or one you have defined.
  12. Choose one or more QuickBooks tables to Add you Microsoft access project” and then click on “OK“.