Exporting to CSV

[McGibbon]

I am doing some work for a company where I need to export data from an access
database, past it into Excel and then export as a CSV. I then use a
pre-programmed web-based interface written in PHP to import the CSV. When I
try and do this, however I am met with a message that states that the file I
am trying to upload is not a valid CSV file. I have opened this file in
notepad and everything appears fine.

Does anyone have any idea what might be blocking this from being recognized
as a CSV file?

Thanks in advance.

Andy

 

[Bob I]

"Quote marks" perhaps. You really haven't said anything about the file
contents.

 

[McGibbon]

The documents contain the name of a theatre, the dollar amount of tickets
sold, the percentage of the total seats sold. There are dollar signs and
percentage signs but no quotes.

 

[Bob I]

Perhaps the interface expects them. Try popping one at both ends of the
string and around each comma. In other words, quote around every field.