update Access Table in Excel
 

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?

update Access Table in Excel
 

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


-----Original Message-----
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?
.

update Access Table in Excel
 

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"



"shin" wrote in message
...
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?