[libreoffice-users] Re: Base created from xlsx file - move to proper DB

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 <alex.thurgood@gmail.com>
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: users+unsubscribe@global.libreoffice.org
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