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+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/ All messages sent to this list will be publicly archived and cannot be deleted