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
Ira,
thanks for the explanation.
My error was that I forgot to define a named range in the XLS file.
Regards
Wilhelm