[Solved] Importing calc-tables to dbase

[Andera]

hello,
I somehow have troubles to find a way to import a calc-table into a database. Can anyone help me on this?
being a newbee on this forum I hope I haven't overlooked an existing answer to this question.
sorry in advance for that and thanks a lot for any help! andrea

[kabing]

There are two different options: 1) connecting to a calc sheet and 2) importing the data into a Base file.

For the second option, seethis article by Solveig Haugland.

This will let you edit the data once you have imported it into the database.

kabing

[Andera]

Thanks a lot!! Your tips and the manual both helped immediately!!
A little problem remained - when importing data, quote marks are changed to combinations of special characters.
I guess this has something to do with the usual status of quote marks in CSV or TXT-Files? But I imported directly from a spread-sheet.
It is not an important problem. But thanks in advance if you have a tip ready on how to solve this, too!
Andera

[KorinNoSeiji]

Am I doing something wrong? When I try to paste the spreadsheet into oBase in the Table object by right clicking, the only options I get are Select All and Database>Advance Settings. It will not allow me the option to paste. Can someone please assist me in understanding what I'm suppose to do to import CSV files into oBase Table Objects?


--Sage

[KorinNoSeiji]

I restarted the applications and it worked. Thanks anyhow!!


--Sage