Noob here on W11 Pro, with MS Office 2000/Access and LO 25.8. I also have LO 25.8 on my LinuxMint 22.2 SSD.
I get our credit card data via a CSV download file. Rearrange it using CALC, adding a Header, etc, saving it as an .xls file. With Access I can click some buttons and my .xls file is appended to my mdb file. very simple.
I’ve tried a copy/paste–but everything gets copied into the cell I point to to start the paste. I’ve tried to save the ods file to a dbf file, but Base does not ‘see’ it where I put it.
Is there an easy solution for this once a month chore? I’m sure other folks have this problem, but after an hour of looking for recent posts–I haven’t found any.
Ron
CSV is not a spreadsheet format. It is not even a file format. CSV is a convention to exchange data between databases.
- Base is not a database. It is a tool to work with databases. You don’t tell us the type of database you are working with. It is indicated in the status bar of your loaded Base document.
- You don’t tell us anything about your specific type of CSV. The type of csv, in particular the way how numbers and dates are encoded, is the most essential info before you can do anything with CSV data.
I can offer a simple Basic routine able to import any flavor of CSV into a HSQLDB without involving any clueless spreadsheet program.
I’ve looked thru the link and tried the copy & paste. My .ods file had the 1st line header, but did not have the index column. It failed with a popup error “Wrong data type: java.lang.IllegalArgumentException
Continue anyway?” Yes but nothing as added.
I added the index column to my .ods file but got the same error.
I had trouble getting the correct JRE installed, since my system is 64 bit and I read somewhere LO 25.8 needs a 32 bit JRE, so I installed that, and then LO worked. LO also shows JRE is installed. There is difference tho, my dates are format 01/01/2025, with no time, some of my columns 32 & 50 character wide. However, except for a few columns which might be different, the column formats are the same in my Base table and my .ods file. Any idea what this means?
It is impossible to tell anything helpful without knowing your source file nor target database.
Villeroy,The previous post was meant for robleyd. this is for you. I did not mean that the csv file was what I used–it’s the format that the bank has me download. It is then copied into CALC and then I install the header, columns are rearranged and after that my data is added. Then it is usually saved as an .xls (MS Excel) file to import into Access. But while trying to get Base to work, I also save the file as .ods file and use that to copy from. Also On the very bottom it says Embedded Database and to the right is says HSQLDB Embedded.
If you want I will post a 2 line odb file, and a 2 line .ods file on Dropbox. I can’t see and icon to post it here.
See this topic; you may find other useful information in the rest of the topic.
My response would be essentially the same. The error “Wrong data type" gives a hint but without seeing the actual data…