OpenOffice Calc+Equivalent to Get External Data in Excel

[Chris Free]

Hello,

I have found no information on how to do the same thing as in Excel in
OOO 2.0.3 that is Get Extrenal Data and Bring in Data from an SQL
Table, sounds pretty basic function. In 1.X it was quite as Excel but
here I am lost...And Itry to create a database and then with f4 to get
the object but it take hours to retrieve 700 lines.... I must do
something wrong so if you can give me some hints it would be cool


Regards

Cheers

Christophe

 

[Al Klein]

I have found no information on how to do the same thing as in Excel in
OOO 2.0.3 that is Get Extrenal Data and Bring in Data from an SQL
Table

Export the data from SQL (I assume you mean MS SQL server) to an Excel
file.

And Itry to create a database and then with f4 to get
the object but it take hours to retrieve 700 lines.... I must do
something wrong so if you can give me some hints it would be cool

Create a database table from Excel? Again - import the Excel file in
SQL Server.

Or, if you can use ODBC connections, you can treat both the Excel file
and the database table as ODBC database connections.
<http://www.connectionstrings.com/>

 

[Craig]

Hello,

..Get Extrenal Data and Bring in Data from an SQL Table,

Christophe;

Did you find an answer to this?

-Craig