Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I write From Excel 2003 to Access 2000? | Excel Discussion (Misc queries) | |||
Using Access in Excel VB Code | Excel Discussion (Misc queries) | |||
Viewing Access Code in Windows 2000 | Excel Discussion (Misc queries) | |||
restricted access in Excel 2000? | Excel Discussion (Misc queries) | |||
How to compare two tables in Access 2000? | Excel Discussion (Misc queries) |