How do I connect to an existing Access database?
Created On
bydwilder
Print SimpleIndex has the ability to export, query or autofill from an Access database. This allows you to upload data that is indexed with SimpleIndex to a table or query, search against the database or pull information from the database based on a key value.
Insert New Data
- Open the Job Settings Wizard and go to the Database step
- Set the Database Mode to Insert New Records
- Click the “New Data Source…: button
- Select the Microsoft Access radio button and click Next
- Click “Browse…” button under “Access Database:”, browse to the database file, select it and click Open
- Click the “Load” button under “Table or View:” and then select the Table or Query that needs to be Inserted to
- Link all of the fields in SimpleIndex to the columns in the database that they should Insert to
Search Existing Data
- Open the Job Settings Wizard and go to the Database step
- Set the Database Mode to Retrieve and View Records
- Click the “New Data Source…: button
- Select the Microsoft Access radio button and click Next
- Click “Browse…” button under “Access Database:”, browse to the database file, select it and click Open
- Click the “Load” button under “Table or View:” and then select the Table or Query that needs to be Inserted to
- Link all of the fields in SimpleIndex to the columns in the database that they should Insert to
Autofill Based on Key Values
- Open the Job Settings Wizard and go to the Indexing & File Naming Step
- Click the “Autofill Settings…” button
- Click the “New Data Source…: button
- Select the Microsoft Access radio button and click Next
- Click “Browse…” button under “Access Database:”, browse to the database file, select it and click Open
- Click the “Load” button under “Table or View:” and then select the Table or Query that is being filled from
- Select the key field for the database column in the “Database Key Field 1:”
- Select the key field for the SimpleIndex index field in the “Index Key Field 1:”
- Set-up the Autofill fields that need to be filled in based on the key field