Unable to load a CSV file into my Database

Ask the community
,
1

I have a CSV file in the following format:

  1. top line lists the fields(columns) in the file separated by comma as follows:
    “_id”,“password”,“fname”,“middle”,“lname”,“address1”,“address2”,“city”,“state”,“zip”,“country”,“phone”,“cell_phone”,“email”,“virtual_email”,“mem status”,“region”,“exp date”,“revised date”,“mailist”,“publish_info”,“payment_info”

  2. beginning on the second line is the data, in quotes, separated by comma.
    “10371”,“cwvega76 “,“JERRY”,“D”,“SMITH”,“1220 SECTION LINE TRAIL”,””,“DELTONA”,“FL”,“32725”,“UNITED STATES”,“386-837-4126 “,“386-837-4126 “,"cwvega76@gmail.com”,"cwvega76@cosworthvega.com”,””,“Region 5”,“07/01/2018”
    06/21/2015" Y",“Y”,“”,"

Total 1404 lines of data.

When I try to import I get an error:

"There was an error parsing this file. Try again or select another file to upload.

2

Nevermind. The file came from a Linux database system. I opened it in Excel and saved it. It is now parsing the file as expected.