Re: [libreoffice-users] Import data from spreadsheet to base

Is your spreadsheet set up as a database with fields? Meaning in the top 
row, something like Column 1 <firstname>, Column 2 <lastname>, Column 3 
<street>, etc. If it is set up like that, I know you can import that 
data into base. If the spreadsheet is setup as a database with fields in 
the top row, you could probably do it from there if it is saved as a 
database and not just a spreadsheet document. I really don't know though 
since you are getting out of the realm of my knowledge. I know you can 
import database information in calc into base, and I know you can have 
great success printing labels from base with the table style templates.

On 03/02/2011 02:38 PM, James Wilde wrote:
> I've checked both LibO and OOo for a how-to or a chapter on this, without luck, and I've checked 
> the Nabble interface to the users maillist.
>
> Is there any easy way to get an address list in a spreadsheet into a base database?
>
> TIA
>
> //James

--

*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~*
Don C. Myers
e-PRO Certified by the National Association of Realtors
Manager, Farm and Rural Property Division
*Coldwell Banker University Realty
*126 East Foster Avenue, State College, PA 16801
Office Phone: 814-237-6543 Fax: 814-237-6502
Home Phone: 814-422-8111 Cell Phone: 814-571-9518
Visit the Farm and Rural Property Division Web Site at 
_www.cbur-ruralproperty.com <http://www.cbur-ruralproperty.com/>
_View Don's Farm Web Site at www.myersfarm.com <http://www.myersfarm.com/>
*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~*


--
Unsubscribe instructions: E-mail to users+help@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***