SO8/Upd5 - CSV-Database Problem

Hallo,

For StarOffice 8.0, Update 5, the definitions of the following ASCII-file for a TXT/CSV data base results in

1) all zeros in column GESCHLECHT, and

2) incorrect values in column ABTNR.

Does anyone know how to solve this problem?

Regards

Hans Beerhalter

=====================================================================

"PERSNR";"PNAME";"PVNAME";"GESCHLECHT";"ABTNR";"EINTRITT";"GEHALT"

9;"Bind";"Gisela";"W";2;1985-05-15;4000.00

8;"Volt";"Gerda";"W";3;1980-02-01;4200.00

7;"Meieris";"Heinz";"M";3;1980-02-01;2450.00

5;"Luft";"Friedrich";"M";3;1985-05-15;4500.00

4;"Strom";"Claudius";"M";2;1984-03-01;3800.00

3;"Meyer";"Luise";"W";4;1984-03-01;2450.00

1;"Eifer";"Rik";"M";4;1980-02-01;3800.00

10;"Meier";"Adam";"M";1;1975-01-01;5000.00

=====================================================================[code][/

[933 byte] By [Beerhaltera] at [2007-11-26 16:41:36]
# 1
Tuesday, January 30, 2007I pasted and copied the file--saved as SCV--and imported into Calc without a problem. I did have to declare that it was semi-colon separated and remove the tick for comma.Phil
PGAGAa at 2007-7-8 23:08:38 > top of Java-index,StarOffice,StarSuite...
# 2

Thank you Phil. - You are impoting to Calc, however, I want to use the CSV-file in SO-Base, which I think doesn't filter the CSV-Data correctly. Is there anyone working on this. There are more problems with SO8-Base that I'll foreward later in toto.

I am grateful for any help.

Hans.

Beerhaltera at 2007-7-8 23:08:38 > top of Java-index,StarOffice,StarSuite...
# 3
Hi Phil,let me add that I want to use my CSV-DB Connection of type TEXT as is and not convert it to a CALC-file. The remaining columns are filtered correctly, therefore there seems something has to be done with the CSV filter.Regards Hans.
Beerhaltera at 2007-7-8 23:08:38 > top of Java-index,StarOffice,StarSuite...