Hey Support
I am working with the new release. So far, I LOVE IT. Here is an issue I am having, so please bear with me. We are exporting data from Excel to a .csv file. The table I am importing to is very generic. It is like
vendor_ID varchar(20) NULL,
vendor_name varchar(50) NULL,
vendor_addr varchar(30) NULL
Okay, I have a cvs file that looks like this:
vendor_ID,vendor_name,vendor_addr
001,"IBM",
002,Dell,"123 Anywhere"
003,"HP","Oregeon"
sometimes I get it to go okay, sometimes I am not. When I worked on the table, I got a lot of import, but of about 2K records, I am only getting about a 6th of them. What shoudl the format for the "correct" input be for smooth import function?
Thanks
Mike