update Access Table in Excel

  • Thread starter Thread starter shin
  • Start date Start date
S

shin

I was wondering if there is code I could write that
updates a table in Access through Excel. I have the exact
setup of the tabel in Excel. It is only 1 column
called "Job Number" and I have a matching table in
Access. Iwant the user to enter a job number and when he
hits a command button, I want the code to update the
Access table with what he has entered. Is that possible?
 
If you link the Excel Sheet to your Access DB any changes
in either will change the other - real time. It's
redundent to have two "tables" of mutually exclusive
data. You only need the Excel file or the database.
Then link them. If it were me I'd create the Excel file
and link it to an Access DB. To link (NOT import) the
Excel to an Access DB open your Access DB. Click Tables,
then right click in the white area where the tables are
stored. Click Link. Select XLS under file type, find
your file, double click it, and that's it.

Marty
 
This might be a help for getting data to and from Excel and Access and how
to UPDATE records:
It includes examples of using variables in SQL queries.
http://www.bygsoftware.com/examples/sql.html

Or you can get there from the "Excel with Access Databases" section on page:
http://www.bygsoftware.com/examples/examples.htm

It demonstrates how to use SQL in Excel's VBA to:

* create a database,
* create a table and add data to it,
* select data from a table,
* delete a table,
* delete a database.

DAO and ADO files available.

You can also download the demonstration file called "excelsql.zip".

The code is open and commented.


--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
 
Back
Top