Using excel workbook to update access database on conditions

**alansidman** · 02-21-2016, 07:55 PM

I have zipped a proforma db with a table which is linked to your excel file. In this manner, any changes you make to the excel file is automatically changed in your database. No need to run append or update queries.

**swade730** · 02-22-2016, 10:11 PM

Originally Posted by alansidman

I have zipped a proforma db with a table which is linked to your excel file. In this manner, any changes you make to the excel file is automatically changed in your database. No need to run append or update queries.

Thank You so much, What do you mean by 'proforma' database?

Using excel workbook to update access database on conditions

LinkBack

Thread Tools

Display

Hybrid View

Re: Using excel workbook to update access database on conditions

Re: Using excel workbook to update access database on conditions

Thread Information

Users Browsing this Thread

Similar Threads

Update Access database from excel worksheet data through SQL in VBA Macro

Insert delete and update from excel userform to access database - help

Excel Data connection to Access database restricts exclusive access to database

Import and update rows in Access database based on date changes from Excel

Update/Delete a Record in an Access 2010 Database using Excel VBA

Converting an Excel workbook to an Access Database

Update Access database through changes in Excel worksheet

Bookmarks

Bookmarks

Posting Permissions