cvs file import that has currency with comma

[everwhat]

How do I import csv file into access when I have a field that has currency with commas?
When I try importing the file, it separate the comma in the amount field that has dollars into two fields

 

[Joe4]

The problem with importing text files, like CSV, into Access is that you need to tell it what the delimiter is, and if there are any text qualifiers (text qualifiers, such as double quotes tell Access that anything between them is literal data, and not to be treated as a delimiter). In CSV files, any commas that aren't between text qualifiers will be treated as delimiters.

So you will either need to have the comma removed before importing, or enclose those values with commas between text qualifiers, so that Access knows that the comma is literal data and not a text qualifier (i.e. "$100,000")

Your best bet would probably be to go back to the source that is creating the CSV file, and have it export the values without commas in them (usually as simple as changing the format of the field it is exporting).