Information générale
Catégorie:
Codage, syntaxe et commandes
>>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
Sorry, that should be SQLTables() instead of SQLColumns().
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement