Thank you Alex and Drew. I'll try your suggestions today. I appreciate your help!
One more question if I might. If I understand correctly, HSQLDB is being replace by Firebird. So I'd like the engine to be Firebird so I don't end up with an issue in the future. How does one know that Firebird is being used? On Thu, 19 Mar 2020 at 05:52, Alexander Thurgood <[email protected]> wrote: > Le 19/03/2020 à 01:57, bunk3m a écrit : > > As Drew has said, you can use your existing flat file in several ways : > > 1) Go via the empty ODB file method to drag the linked XLSX sheet from > your first ODB file to the second, empty ODB file and then follow the > import wizard. > > 2) Create an empty ODB file and keep it open. Open your XLSX sheet > directly in LO Calc. Select all of the data including column headers, > that you want to import. > Drag and drop this selected data onto your open ODB. > Use the import wizard options to configure the way you want the data to > be imported into a new table that will be created as a result of the > drag and drop maneuver. > > Be aware that the import wizard isn't perfect, depending on the version > of LO you are using, it might cause you a bit of grief, so double-check > afterwards that it has done what you wanted (within the confines of what > it can actually do, of course). You might find that some post-import > database alteration statements might be necessary. > > > Alex > -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
