On Mon, 11 Feb 2008 09:40:31 -0800 NoOp <[EMAIL PROTECTED]> dijo: > On 02/10/2008 09:42 PM, John Jason Jordan wrote: > > On Mon, 11 Feb 2008 08:05:29 +0300 > > Kirill Palagin <[EMAIL PROTECTED]> dijo: > > > >> File - New - Database- Connect to an existing DB-Text-Next - Browse to > >> your csv. > > > > Unfortunately, when I browse to the .csv file the file is grayed out. > > > >> Alternatively you can Copy-Paste your data from Calc to Tables folder in > >> Base. > > > > That doesn't work at all. I can select the entire table in Calc, copy > > to the clipboard, but Paste in the Base file is grayed out. I also > > can't drag and drop it to the Base tables folder. > > Open the csv file in Calc, save as an odt. You can then open in Base as > a spreadsheet - that does work. Don't know why the text/csv isn't > working, but the odt does.
That almost worked. Actually, I got the .csv file into a table in Base, but it truncated some of the fields. That is, the original Access table had many fields defined as "memo" which, in Access-speak, means "text, no limit." Base truncated them to 255 characters. I looked at the field types in Base and it's not clear if there is a field type like "memo." The terms for the Base field types are not in any language I speak. :( It's possible that the truncation occurred in Kexi, because I used Kexi to import the Access file, then exported the table from Kexi as .csv. However, Kexi never threw up any error messages in either process, where Base did say something about "exceeding something-or-another." I did try telling Base to open it with the Auto button, but maybe I need to specify which type each field is. Also, the table seems to be read-only, and I can't find any buttons to make it editable. Furthermore, as I said before, the original Access file has 43 tables in it. If I have to go through this for each one it's going to be painful. It seems that I might be able to do it one table at a time, but a way better solution would be to figure out how to get OOo to use the data directly from Kexi. Kexi is Access-like, not only in the GUI interface but, because its format is sqlite3 it holds as many tables and all their associated queries, forms and reports as you want all in the same file. If you haven't guessed by now, I've become a fan of Kexi. Kexi thinks like I do. I have received a like (from Drew) to instructions for getting OOo to read sqlite3 files. Unfortunately, the instructions are in a PDF file that is a couple years old. Links for drivers and files are mostly broken and, even if I can get them, they may not be available for 64-bit Ubuntu, and after all that who knows if it will still work with OOo 2.3. I'll keep poking at things. Thanks for the suggestions. I'm slowly making progress. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
