OpenOffice macros provide an interface between a programmer and one particular office suite (or two since LibreOffice is still API compatible with OpenOffice). SQL is a universal description language to databases (since the 70ies more or less the same for almost all databases). Once you have wrong data in the spreadsheet (which may look right) you can not expect any software to turn them into correct data. If the data flavours of the text files are different (different separators, column orders, numeric formats etc.), you should use Calc with correct parameters to import the correct data types, hit F4 and then drag the data range onto the 'Tables' icon of your registered database (no, you can NOT paste row sets into the grid view of an opened row set).

Various databases (HSQL, MySQL, PSQL, MS, Oracle) provide many different ways to import text and you may even use Base. The one and only purpose of databases is that you never have to copy around data to different storages in different file formats.

open office OpenOffice.If you exported your csv data from some kind of standard database you should simply connect a Base document to that database and use it directly. Window, specify the type of character you want to separate columns,

Save As and select the same Text CSV format in the file format list. The other way around-you've got a spreadsheet and you want it to be To specify, you can do that column by column.ĭone, just click OK. Same window, if you have date-format data or other formats you want (Click the picture to see a larger version, if you want.) Window where you specify how the file was created: what separates theĭata into columns, etc. The window should now look like this, so just click Open. List of types, or you can click in the file type list and press TĤ. (Click the picture to see a larger version of it, if you want.) You can be in Writer, Draw, Calc-it doesn't matter. The trouble is, in, if you just choose File > Open, the Comma-delimted files are a common way to get data out of a spreadsheet or database and into another. Separated by tabs or commas rather than columns in a spreadsheet, and Spreadsheet? Basically, you've got data in rows and columns, but To press Return in the upper left cell of the table.) )Ībove a table that's at the top of a document? (You now simply have Things people always asked, that were hard to figure out.Ĭolumns on every page of a spreadsheet? (See this post.

Openoffice draw csv connect