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

Hi Jim,

In Windows I used Word Perfect Office until OpenOffice was in late beta, 
roughly 10 years ago. I moved to OpenOffice back then, except then 
OpenOffice 1.0 did not have a database, so I continued to use Paradox 
from the Word Perfect Office suite. Once OpenOffice had a database, I 
think it was in version 2.0, I migrated my Paradox database to 
OpenOffice base. That process involved exporting the Paradox data to a 
QuatroPro spreadsheet, converting it to an Excel spreadsheet so it could 
be read in OpenOffice calc, and then importing the data into OpenOffice 
base. That was all done 7 to 8 years ago, so I don't remember the 
details. I did find a tutorial on line back then that guided me in the 
process, so maybe you can find a tutorial which will help you out. I'm 
sorry I can't do better.

Don

On 03/02/2011 03:07 PM, James Wilde wrote:
> Thanks, Don, this isn't my day.
>
> I can see no way to save my calc as a database under Save as.  I can find no import option in base. 
>  And copying the entire sheet and pasting to the first field on a form doesn't work.
>
> Another thing:  the column names in the base table are not in exact conformance with the column 
> names in the calc sheet.  The one is in English, for example, the other in Swedish, and I was 
> hoping for a procedure to assign field names in the one to field names in the other.
>
> //James
>
> On Mar 2, 2011, at 20:52 , Don C. Myers wrote:
>
> > 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 ***

--

*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~*
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 ***