MB Software Solutions wrote:
Jeff Johnson wrote:
Paul: I have done this hundreds of times using ODBC. Very straight forward
and you can SCAN the access tables and write to the DBF.
So post some sample code for him, Jeff! g
Yes, go on Jeff, please. Pretty please !
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Paul Newton
Sent: Wednesday, January 31, 2007 5:27 PM
To: [EMAIL PROTECTED]
Subject: Re: Access automation
Tx Jeff
Jeff Johnson wrote:
Paul: I have done this hundreds of times using ODBC. Very straight
Hi all
I am trying to get a list of tables in an MS Access MDB and what I have
so far is
oAcc = CREATEOBJECT(Access.Application
oAcc.OpenCurrentDatabase(MyDatabase.MDB)
LOCAL lnTables
lnTables = oAcc.CurrentData.AllTables.Count
This returns a value of 9 for lnTables but the MDB only contains 2
Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Paul Newton
Sent: Wednesday, January 31, 2007 5:13 PM
To: profox@leafe.com
Subject: Access automation
Hi all
I am trying to get a list of tables in an MS Access MDB and what I have
so far is
oAcc = CREATEOBJECT
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Paul Newton
Sent: Wednesday, January 31, 2007 4:13 PM
To: [EMAIL PROTECTED]
Subject: Access automation
Hi all
I am trying to get a list of tables in an MS Access MDB and what I have
so far is
oAcc
lctable=oacc.CurrentData.AllTables(i).name
IF OCCURS('MSys',lctable)=0
?lctable
endif
endfor
John
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Paul Newton
Sent: Wednesday, January 31, 2007 5:13 PM
To: profox@leafe.com
Subject: Access automation
Hi
Tx Jeff
Jeff Johnson wrote:
Paul: I have done this hundreds of times using ODBC. Very straight forward
and you can SCAN the access tables and write to the DBF.
That would be using SPT (SQLConnect and SQLExec) right ? And this would
be another approach - in addition to (i) ADO and (ii)
Thank you John but I did ask
How can I get a count/list of the tables excluding the system tables
(without iterating all of them to exclude the system tables) ?
john harvey wrote:
I just checked the code in Access 2007 and found they are using 0 based
arrays, so modify the code to
Jeff Johnson wrote:
Paul: I have done this hundreds of times using ODBC. Very straight forward
and you can SCAN the access tables and write to the DBF.
So post some sample code for him, Jeff! g
--
Michael J. Babcock, MCP
MB Software Solutions, LLC
http://mbsoftwaresolutions.com
9 matches
Mail list logo