Import data.
Posted: Wed Aug 10, 2011 12:14 pm
I have my revised menu items in an Excel spread sheet.
I save it as an CSV (comma delimited) file but get these error reports when I try to import it.
"line 1 'item' is not a valid floating point value.
or
Line1: SQL Error: validataion error for column APPLYTAX, value "***null***, Error code -625. The insert failed because a columb definition includes validation constraints. The SQL: INSERT INTO Item(code,note)VALUES(?,?);;
Any ideas?
Thanks
I save it as an CSV (comma delimited) file but get these error reports when I try to import it.
"line 1 'item' is not a valid floating point value.
or
Line1: SQL Error: validataion error for column APPLYTAX, value "***null***, Error code -625. The insert failed because a columb definition includes validation constraints. The SQL: INSERT INTO Item(code,note)VALUES(?,?);;
Any ideas?
Thanks