OpenOffice Calc+Equivalent to Get External Data in Excel

  • Thread starter Thread starter Chris Free
  • Start date Start date
C

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
 
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
Click to expand...

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
Click to expand...

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/>
 
Back
Top