Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>Hi Rene,
>>
>>You can use SQLSTRINGCONNECT to create a connection to any database. You must define first an ODBC connection at your Control Panel.
>>After that you'll see the tables from the other data source.
>>
>>Say something.
>>
>>Ric
>
>Well, I used sqlconnect to an Excel file just for starters and it returns a positive connection handle, which is good. But what now? I tried SQLexec(6,"SELECT * from bugs.dsn","Test"), SQLexec(6,"SELECT * from bugs.xls","Test") and SQLexec(6,"SELECT * from bugs","Test"), but it returns -1 (6 being the connection handle).
>
>Would appreciate some help, I'm sure it must be very simple. Thanks.
>
>René
Think I found it: you have to create a remote view, that's it isn't it?
Seems to work fine. Still would like any suggestions. Thanks.
Précédent
Suivant
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