I need to be able to export data from a split database as such that a template is created that can be read into an external database.
One of the sticking points is that the template has a header with double lines in one cell. Top line is in English; bottom in French.
Example:
Email
Courriel
If not both are used, the template will not be accepted into a MS DataBase.
It appears it is the principle as what Calc does allow, by using Shift+Enter in a Cell, but I cannot seem to recreate it with the use of SQL.
I would like either to export directly into the xlsx format template, or even better recreate the template myself.
Can someone please provide me with some guidance?
Dream