Link to home
Start Free TrialLog in
Avatar of Mitch Swetsky
Mitch SwetskyFlag for United States of America

asked on

Access importing CSV that has commas in currency and needs 2 cols formated for numbers to text

I have a csv file which has currency that includes a comma and is enclosed in double quotes  
The IDNum values are also alphanumeric but not in the first rows so that field is being seen as numeric and removing the alpha records.

As a random example:

Name,IDNum,Value,Active
Jane,12344,"1,240.00",Yes
John,12H569,679.12,Yes

I can open the csv in excel and save it as XLS which will save the correct values but I am having trouble with the vba manipulation code, so I was wondering if an import spec would be better.

I am trying to create this in vba
Can someone help me or point me to a solution?
SOLUTION
Avatar of aikimark
aikimark
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mitch Swetsky

ASKER

Thank you all