Having trouble uploading .csv file into mySQL
Posted: Tue Aug 21, 2007 6:12 pm
I'm trying to use phpmyAdmin to import a file. I keep getting a "invalid field cont in csv file" error. At present I am trying to test the process. The error is on this line.
Field 1:
Air Products' Internet Strategy
Field 2:
Air Products and Chemicals Inc., a leading chemicals and gases company, employed 15,000 people worldwide. In fiscal year 1995 Air Products' sales were up 11% to $3.9 billion; net income was $368 million; and cash flow reached $797 million-all records. The capital-intensive company was rapidly expanding internationally, and it was up to the Management Information Systems (MIS) Vice President, Peter Mather, to design the technological infrastructure that would continue to enable the expansion. Mather's core MIS group developed the infrastructure and cross information technology services supporting the business areas of Air Products worldwide. After 29 years with the company, Mather carried a blueprint in his mind of criss-crossing and overlapping telecommunications networks, wide area networks, local area networks; and layers of enterprise-wide services including electronic mail, video conferencing and the electronic desktop. However promising the commercial Internet appeared, Mather believed that it would provide little value to the company unless it fit appropriately into Air Products' larger technological infrastructure. What would the costs and revenue stream look like in the "electronic frontier?"
I suspect it is because of some of the punctuation in the fields but they cannot be changed. Can anyone suggest a way around this. My table name is called Application. The fields are called Title and Description. Thanks
Field 1:
Air Products' Internet Strategy
Field 2:
Air Products and Chemicals Inc., a leading chemicals and gases company, employed 15,000 people worldwide. In fiscal year 1995 Air Products' sales were up 11% to $3.9 billion; net income was $368 million; and cash flow reached $797 million-all records. The capital-intensive company was rapidly expanding internationally, and it was up to the Management Information Systems (MIS) Vice President, Peter Mather, to design the technological infrastructure that would continue to enable the expansion. Mather's core MIS group developed the infrastructure and cross information technology services supporting the business areas of Air Products worldwide. After 29 years with the company, Mather carried a blueprint in his mind of criss-crossing and overlapping telecommunications networks, wide area networks, local area networks; and layers of enterprise-wide services including electronic mail, video conferencing and the electronic desktop. However promising the commercial Internet appeared, Mather believed that it would provide little value to the company unless it fit appropriately into Air Products' larger technological infrastructure. What would the costs and revenue stream look like in the "electronic frontier?"
I suspect it is because of some of the punctuation in the fields but they cannot be changed. Can anyone suggest a way around this. My table name is called Application. The fields are called Title and Description. Thanks