Re: [libreoffice-users] Re: Calc as a Flat File Database

Hi Alexander and all:

        Thank you for your clear explanation. If I understood you well, this
happen when we predefined the table in Base that we think that we will
need. But when I have needed do it, I didn't make the table, I only use
connect option (when start BASE), with a .db (spreadsheet -.ods-) that I
have in my file directory. I think that in this way BASE create the
table with the characteristic of the origin (.ods file).

Regards,

Jorge Rodríguez


El jue, 17-03-2016 a las 16:35 +0100, Alexander Thurgood escribió:
> Le 17/03/2016 16:08, jorge a écrit :
>
>
> Hi Jorge,
>
> >     I suggest to you to open the .CSV file with CALC. Then save it as .ODS.
> > Finally, import from BASE the .ODS file.
>
> The import wizard from Calc to Base is not perfect, so unless one is
> absolutely sure that the data in your CSV or Calc file exactly matches
> the definition of the fields in the table, then one should expect either
> import errors or failure. Particular things to watch out for :
>
> - date / time / datetime representations
> - text values over integers
> - null fields
> - values intended to be used in an autoincrement field
> - boolean values
> - memo fields
> - unsigned INT field values
> - zero-fill values
>
> etc, etc
>
>
> Alex

-- 
Atentamente,

Jorge Rodríguez


-- 
To unsubscribe e-mail to: users+unsubscribe@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/
All messages sent to this list will be publicly archived and cannot be deleted