RE: List of tables in an ODBC Access mdb

Author: <henry.dagher@hrsdc-rhdcc.gc.ca>

Posted: 2007-03-22 at 14:54:19

Awesome! Thanks, Chet.

Henry

-----Original Message-----

From: profoxtech-bounces@leafe.com [mailto:profoxtech-bounces@leafe.com] On Behalf Of Chet Gardiner

Sent: 2007-03-22 3:30 PM

To: profoxtech@leafe.com

Subject: Re: List of tables in an ODBC Access mdb

I've included a program below that will:

1) Open the MDB

2) Create a cursor containing the table names

3) Create a cursor containing all the field names

4) Select all the records from the Access table(s)

and copy them to a dbf

Have fun!

©2007 <henry.dagher@hrsdc-rhdcc.gc.ca>