>>Hi Sergey,
>> This solution requires Access 2000 or newer, which I do not have. I do have Access97, but I would like to do this directly without Access, if possible.
>
>Programmatically, you can do this with a combination of ADOX and ADO. With ADOX you would look at the catalog object and tables collection to get the names and then obtain the data with an ADO rs object.
>
>For an example of this, download the ADOGetRows.jcRStoCursor utility from the downloads section here in UT. The test program (I think it's called testmyrs.prg or something like that) has exactly what you would do if you choose to go this way.
>
>Alternatively you can use SPT, SQLColumns() and SQLExec() with the ODBC driver for Access.
>
>HTH

I guess I should have said PMFJI..