Trying to import calc info into Base

[CakesbyCora]

hello-

I have put together a customer list in Calc and want to transfer or import it into basw so I can have a proper database of my customers and various pieces of info relating to each customer. I have tried to cut and past the info from calc into base, and all it does is past the whose calc spreadsheet into the first cell in the data base. How do I copy a base file with multiple columns and rows into database?

I am new to open office org and not a computer genius...I am a total END USER. Please put any answer or response way on the bottom shelf for me.

Thanks in advance for any help!!

[r4zoli]

Select whole sheet, and drop into table area in odb file, copy wizard will came up. Follow it and add primary key.

[chancm16]

I tried to do that: I copied the spreadsheet in calc and opened a new table in base. But when I pasted the data, it just copied 50 characters into the first field. Do you know what I'm doing wrong?

[Villeroy]

Don't drop into the loaded view of the table. Drop into the tables area of the database window.

[Sniffle]

Basically you just need to create the database file and make sure it's registered. For what you are doing you do not need to create the table. That will happen from inside Calc.

Create your database and have it registered.
Open your Calc spreadsheet and make sure it looks as you want your tables, with column labels across the top.
Hit the "Data Source" button.
Find the database you had created and expand it.
Select your entire spreadsheet (ctrl-a) and drag it up to the Tables folder under your database.
A wizard will open to create (or append to) a table.

There are other resources available on the forums to explain Base more in-depth but one thing to keep in mind is that tables should have a primary key which is one column that does not contain any repeat entries. You can have the wizard create a primary key which will add a column in the table and just number each row. Or if you already have a unique column such as customer# or transaction# then you can tell the wizard not to create the key and you can manually edit the table in Base to make one of those columns the key.

[marcov]

Select whole sheet, and drop into table area in odb file, copy wizard will came up. Follow it and add primary key.

Am I incorrect that this fails if you have (memo) fields with linebreaks in them?

[Villeroy]

Select whole sheet, and drop into table area in odb file, copy wizard will came up. Follow it and add primary key.

Am I incorrect that this fails if you have (memo) fields with linebreaks in them?

A spreadsheet has no memo fields. It has either one of text, floating point number (double), blank cell or some error value.

[jakes]

Or you can right click onto the the Tables area of your database and choose paste. Then in the "Copy Table" dialog you can put the name of a current table in the database for the "Table name" and choose the "Append data" radio button and click "Create". Data is now appended into the table.