[libreoffice-users] Re: Batch conversion from csv

Am 24.07.2012 13:34, Michael Crider wrote:
> I have csv files generated from an SQL command-line utility that I am
> trying to convert to dBase using the batch converter. If I open the csv
> in LibreOffice, a default option is "Quoted fields as text", and if it
> is saved as another filetype, those fields remain text, but when using
> the batch converter it will bring all numbers in as numbers, even if
> they are quoted. The command I am using is:
> libreoffice --headless --invisible --convert-to dbf *.csv
> I have the same results if I convert to other spreadsheet types. Is
> there a way to tell the batch converter to convert "quoted fields as text"?

CSV is a database exchange format. dBase is a database in a directory. 
Why do you try to load csv into spreadsheets?
Why csv at all? Probably you can connect Base to the database and use it 
directly. Base is a versatile tool to serve database data to office 
documents and it can be used to move data from one database type to another.


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted