This is driving me crazy! I need to export a small table (10 records, 8 fields) from Access 2007 to Excel csv. I have exported from Access to Excel workbook and then saved the workbook as a csv file. (I have also tried exporting to xml, html, binary, and other formats; and then importing to Excel, but no luck.)
Next, I need to import the csv file into Wordpress (mysql). The problem is that there are little squares at the ends of the fields (line breaks? carriage returns?) that stop the file from importing. I can't actually see the squares on my computer, but can see them on a friend's computer (in Notepad).
Also, one of the Access fields is a memo field. That field ends up having quotes around it in the Excel formats.
How can I get rid of the squares and the quotes around the memo field, or avoid them altogether?
Thanks so much!
Jillie
Next, I need to import the csv file into Wordpress (mysql). The problem is that there are little squares at the ends of the fields (line breaks? carriage returns?) that stop the file from importing. I can't actually see the squares on my computer, but can see them on a friend's computer (in Notepad).
Also, one of the Access fields is a memo field. That field ends up having quotes around it in the Excel formats.
How can I get rid of the squares and the quotes around the memo field, or avoid them altogether?
Thanks so much!
Jillie
