I am working through the documentation for the forms. To do this
properly I needed a data base. As I have an access data base which I
want to convert to Librebase I used this. I exported the tables from
Access as Excel files, opened them in Librecalc, saved them in native
librecalc format. I made sure the column definitions were correct for dates.
I copied the data cells and imported them into a Base table. I found a
problem with all fields which were created as text. If I change the
date columns to date format I cannot save the new version of the base
table without losing the date data. Is there any way of importing data
and preserving the data format?
Many years ago using Oracle SQL I believe you could import text data
into an already created table if your text data had been properly
formatted. Is this possible with LibreBase?
Thanks for an advice.
This won't stop me from continuing to reviews the documentation but it
would be good to know how to import data , retaining the formatting and
data types.
Regards
Peter Goggin
--
To unsubscribe e-mail to: documentation+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/documentation/
All messages sent to this list will be publicly archived and cannot be deleted