Comma Delimited Files

These files are usually created from a database application when exporting data. Below is an example of the file format that Easy Access accepts. The first line is a header that can be used on importing to identify record field names. It should not be imported.

LAST,FIRST,MIDDLE,SSN,ADDR1,CITY,STATE,ZIP,REF1,REF2
Acceptance,Michael,,400-10-1121,3842 S Michigan,Fantasy Island,IL,60750,Reference1,Reference2
Consumer,Jonathan,Quincy,999-99-9990,10655 Birch ST,Burbank,CA,91502,,Reference 2
System,Test,,022-28-1852,54321 N Main St,Oz,GA,00999,Reference1,
(blank line)

Commas separate fields, and carriage returns/linefeeds separate records. If your fields contain commas, use quotation marks to delimit the record field.

Each record must end with a carriage return/linefeed, or it will not be imported correctly.

Record formats can vary. Another sample import file is shown below. This import file has no header, so all lines are imported.

Michael Acceptance,400101121,3842 S Michigan,”Fantasy Island,IL 60750″
Jonathan Quincy Consumer,999999990,10655 Birch St,”Burbank,CA 91502″
Test System,022281852,54321 N Main St,”Oz,GA 00999″
(blank line)

Comments are closed.