I have several Calc files that I want to import into one Base table. Each Calc file has three fields: Date (formatted as DATE) and two text fields. The fields in the Base table are formatted the same as in the Calc files and the column names match. The ID field populates itself fine. The problem is that when I paste a new file, Base pastes the dates from the previous file into the table.
For instance, the first Calc file had 5-May as the date on all the records. This went over fine. The second Calc file had 6-May on all the records. These all showed up as 5-May in the table. I’ve tried it about six times by now, but still get the same results.
I’m using a PC with the latest version of LibreOffice.
Any ideas?