This is a leftover question from an earlier post on ODBC connection.

Is it possible to acces Excel and Word documents through ODBC connection? If the answer is yes, could somebody please indicate suggested reading materials, or clues to look for info.

Regards

Wilhelm

I think the questions should read this way:

a) How can I open an Excel file through the C/S workspace? Are there any formatting requirements for .XLS files?

b) Is there an ODBC driver for WORD available?

Regards

Wilhelm

Wilhelm,

Yes it is possible. Here are the general steps for Excel:

1) The data is stored as rows, with the first row as the column names. Create a named range for the data, as follows:

– Highlight the range.

– From the Insert menu, click Name, then Define

– Enter a range name (say, MyData)

2) Create an ODBC connection to Excel - use the Microsoft Excel driver, and point it to your Excel file.

3) In OpenInsight, create a connection in the Client/Server Manager using the same DataSource name you defined in (2).

4) Go to the Query window, select the connection you defined in (3).

One note: the Excel driver does not support transaction processing, so you need to clear the Transaction checkbox.

The query:

Select * from MyData

should retrieve all the columns from the range you specified.

You should also be able to do this in BASIC+ code using XO() and Qry() family of functions.

Hope this helps.

Ira Krakow

ikrakow_1999@yahoo.com

Ira,

thanks for the explanation.

My error was that I forgot to define a named range in the XLS file.

Regards

Wilhelm

View this thread on the forum...