Menu

#4979 (ok 4.4.12) Problem when import *.ods file

4.4.11
resolved
None
Normal
2015-07-14
2015-07-12
No

I've create a database on excel and saved him as Open document spreadsheet, but when i try to import him, i browse and select file, select "The first line contain the column name" option and press the continue button, i have an error message saying " MySQL #1117 Too many columns" and display the query showing the column names of my table, and include the column names of the excel sheet

'idpatient' int(1), 'name' varchar(10), 'lastname' varchar(10), 'phone' int(10), 'adress' varchar(10), ....... , 'L' varchar(10), 'M' varchar(10), 'N'varchar(10), 'O' varchar(10)

'idpatient', 'name', 'lastname', 'phone', 'adress' are column names of my table
The 'L', 'M', 'N', 'O', are excel column names

Discussion

  • Madhura Jayaratne

    • assigned_to: Madhura Jayaratne
     
  • Madhura Jayaratne

    Can you attach a small .ods file that gives this error, obfuscating any sensitive data

     
  • Ricardo Martinez

    Thanks for the quick replay, this is the file
    Error message says the problem is in the "productos" table

     

    Last edit: Ricardo Martinez 2015-07-13
  • Madhura Jayaratne

    • summary: Problem when import .ods file --> (ok 4.4.12) Problem when import .ods file
    • status: open --> resolved
     
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.