Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Andy Kramek
  Where is Andy Kramek?
 Hot Springs Village
 Arkansas - United States
 Andy Kramek
 To: sbr Abdullah
  Where is sbr Abdullah?
 fuj
 United Arab Emirates
 sbr Abdullah
 Tags
Subject: RE: names of MS Access database tables into array
Thread ID: 50700 Message ID: 50712 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Sunday, September 05, 2004 2:10:24 PM         
   


Hi

> can any one tell me how to put names of MS Access database tables into array?

First you will need to create an ODBC connection to the Access Database and get the connection handle.

Then you can use SQLTABLES() to get a cursor containing details of all the tables

Once you have the cursor you can do whatever you need to with the data. (You can also use SQLCOLUMNS() to get field lists for a table)


Regards
Andy Kramek
Microsoft MVP (Visual FoxPro)
Akron, OH, USA

ENTIRE THREAD

names of MS Access database tables into array Posted by sbr Abdullah @ 9/5/2004 8:40:48 AM
RE: names of MS Access database tables into array Posted by Pete Sass @ 9/5/2004 11:18:34 AM
RE: names of MS Access database tables into array Posted by Andy Kramek @ 9/5/2004 2:10:24 PM
RE: names of MS Access database tables into array Posted by sbr Abdullah @ 9/5/2004 3:16:35 PM