openoffice.org can't use text database in calc or base
Hi, I have a Comma delimited text file in the format
"data1","data2","data3","data4",etc,etc
In oocalc When I do insert/link to external data and select the file, and select comma delimited. I click ok then it returns me to the file selection box but "ok" os not selected so I can't use the database. I tried in version 1.1 and also 2.0 beta. It does it in both. What am I doing wrong?
I also tried doing it in the Base application I can get the database but it gives me one row for all the data even though I selected csv and the commas are there and there are linebreaks.
Any suggestions please?
thanks
bb
|