Re: List of tables in an ODBC Access mdb

2007-03-23 Thread Andy Davies
try MDB Browser -- Author: S.Arnold I think I got it from this list - otherwise Google is your friend s. Andrew Davies  MBCS CITP   - AndyD    8-)# ** This email and any files transmitted with it are confidential and

Re: List of tables in an ODBC Access mdb

2007-03-22 Thread Vince Teachout
[EMAIL PROTECTED] wrote: I am trying to analyze an undocumented Oracle data model. The DB has been dumped into an Access mdb for me. Using VFP (of course), I'm trying to read in the names of all the tables (100+) in the mdb so I can programmatically create remote views. My ultimate goal

Re: List of tables in an ODBC Access mdb

2007-03-22 Thread Chet Gardiner
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! *-- GetAccess.prg *-- *-- Extract list of tables,

RE: List of tables in an ODBC Access mdb

2007-03-22 Thread henry.dagher
Awesome! Thanks, Chet. Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chet Gardiner Sent: 2007-03-22 3:30 PM To: [EMAIL PROTECTED] Subject: Re: List of tables in an ODBC Access mdb I've included a program below that will: 1) Open the MDB 2