>>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.