Discussion Locked

Displaying the tables from a Access File

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am trying to take data from ms access file in runtime.. The program is first user has to select the ms access file. Then i have to display all the tables in it. Then user will select the table.. After which i will display the columns and user has to select..I hve handled this in oracle..

Now i want assistance for displaying the table name and column name..

Could anyone assist me

regards
lakks

1 reply

by tony hopkinson

Access has as you've no doubt gathered no equivalents for the sys... meta tables you see in full DBMSs.

Googling ADOX show tables
will give you some useful hits in the morass.

This discussion is closed to new replies.