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: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ Privacy Policy: http://www.documentfoundation.org/privacy
