XL2000 VBA code to ACCESS 2000
 

Besides the 'Sample' code provided with XL97 & XL2000 does
anyone have a good working example of EXCEL 2000 opening,
inquiry, reads and updates to ACCESS 2000 tables.

Download should contain the ACCESS MDB, tables and EXCEL
VBA code to access ACCESS....

TIA

XL2000 VBA code to ACCESS 2000
 

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 and add data to it,
* select data from a table,
* delete a table,
* delete a database.

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

The code is open and commented.


--

Regards
Andy Wiggins
www.BygSoftware.com
Home of "The Excel Auditor" and "Byg Tools for VBA"



"Tom Rudski" wrote in message
...
Besides the 'Sample' code provided with XL97 & XL2000 does
anyone have a good working example of EXCEL 2000 opening,
inquiry, reads and updates to ACCESS 2000 tables.

Download should contain the ACCESS MDB, tables and EXCEL
VBA code to access ACCESS....

TIA