Hi,

Is it possible to update an Access DB from within Excel?

Thanks

http://groups.google.co.uk/groups?hl...gle.com&rnum=6


--
Regards,
Tom Ogilvy


"sanj" wrote in message
...
Hi,

Is it possible to update an Access DB from within Excel?

Thanks

Yes you can using DAO or ADO use help and internet search for topics

--
Cheers
Nigel



"sanj" wrote in message
...
Hi,

Is it possible to update an Access DB from within Excel?

Thanks

Thanks Nigel and Tom!



"Nigel" wrote in message
...
Yes you can using DAO or ADO use help and internet search for topics

--
Cheers
Nigel



"sanj" wrote in message
...
Hi,

Is it possible to update an Access DB from within Excel?

Thanks

This might be a help for getting data to and from Excel and Access: 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
* insert records
* select records,
* update records,
* delete records,
* 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 FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy


"sanj" wrote in message
...
Hi,

Is it possible to update an Access DB from within Excel?

Thanks