-----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 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) automation ? Paul: What I do is create a DBC and then use the query wizard - remote query - to add the connection and tables to the DBC. You can investigate the DBC or cut and paste from GENDBC to write your programs or whatever to access the Access tables programmatically using SQLConnect and SQLExec. HTH Jeff Jeff Johnson [EMAIL PROTECTED] 623-582-0323 Fax 623-869-0675 --- StripMime Report -- processed MIME parts --- multipart/signed text/plain (text body -- kept) application/x-pkcs7-signature --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
