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
Can you attach a small .ods file that gives this error, obfuscating any sensitive data
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