Re: [libreoffice-users] How can I import excel file to libreoffice base as data souces

2012-01-08 Thread jorge
Hi:

I suggest you to do this:

1) Open BASE program
2) Select third opción (Connect database exist)
3) Select below Spreadsheet and following find the .xls that you need to
include in database.
4) Open database (Save) and use. Base will get all sheets that the .xls
has and convert each one to a database table

Regards,

Jorge Rodríguez
___


El dom, 08-01-2012 a las 07:59 -0800, bobby_winon escribió:
> hello everybody , I am new to the libreoffice ,and I wish someone can tell me
> how can I import excel file to libreoffice base as data source.thank u for
> your noticed
> 
> --
> View this message in context: 
> http://nabble.documentfoundation.org/How-can-I-import-excel-file-to-libreoffice-base-as-data-souces-tp3642216p3642216.html
> Sent from the Users mailing list archive at Nabble.com.
> 

-- 
Atentamente,

Jorge Rodríguez


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


Re: [libreoffice-users] How can I import excel file to libreoffice base as data souces

2012-01-08 Thread Tom Davies
Hi :)
Excel is a spreadsheet program and the equivalent in LibreOFfice is Calc.  It 
might well be better to use a database program to read many types of 
spreadsheets but possibly what you are looking for is Calc.  

See documentation at
http://wiki.documentfoundation.org/Documentation/Publications#Getting_Started_with_LibreOffice

Usually you can just double-click on a .xls or .xlsX to open it in Calc.  If 
that doesn't work yet then try right-click on the file and choose LibreOffice 
or Calc from the "Open with..." option.  The first time you use Calc it might 
be that you have to just open LibreOffice and then drag&drop the file onto the 
main-menu / splash-screen.  From then on LibreOffice or Calc should appear in 
the right-click menu on that machine.  

It is also possible to right-click and choose "Properties" to change the 
default program used for opening such files.  Once that is done then just 
double-clicking the file will open it in the right app.  You could always 
change that again later.  

It really depends on what Operating System you are using and what options you 
chose during the LibreOffice install.  The above all assumes Windows or 
Gnu&Linux but wouldn't work quite the same on Mac.  There is an equivalent.  
Most Gnu&Linux distros such as Ubuntu, Mint, Fedora, Mageia, RedHat etc will 
let you just double-click to open the spreadsheets in Calc.  

Probably you know all this sort of thing already but a surprising number of 
people don't.  
Regards from
Tom :)


--- On Sun, 8/1/12, jorge  wrote:

From: jorge 
Subject: Re: [libreoffice-users] How can I import excel file to libreoffice 
base as data souces
To: users@global.libreoffice.org
Date: Sunday, 8 January, 2012, 17:15

Hi:

    I suggest you to do this:

1) Open BASE program
2) Select third opción (Connect database exist)
3) Select below Spreadsheet and following find the .xls that you need to
include in database.
4) Open database (Save) and use. Base will get all sheets that the .xls
has and convert each one to a database table

Regards,

Jorge Rodríguez
___


El dom, 08-01-2012 a las 07:59 -0800, bobby_winon escribió:
> hello everybody , I am new to the libreoffice ,and I wish someone can tell me
> how can I import excel file to libreoffice base as data source.thank u for
> your noticed
> 
> --
> View this message in context: 
> http://nabble.documentfoundation.org/How-can-I-import-excel-file-to-libreoffice-base-as-data-souces-tp3642216p3642216.html
> Sent from the Users mailing list archive at Nabble.com.
> 

-- 
Atentamente,

Jorge Rodríguez


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted