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


sbr
Thanks freinds it is working


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