CSV Schema File

• A CSV (Comma Separated Value) schema file defines the structure of your data.
• Common file name for CSV Schema is schema.ini
• CSV Schema File is commonly using in ODBC Data Source Administrator

schema.ini example:

[CartoonCharacter.csv]

ColNameHeader=True

Format=CSVDelimited(;)

MaxScanRow=17

CharacterSet=OEM

DecimalSymbol=.

Col1="No" Float Width 3

Col2="Cartoon Name" Text Width 21

Col3="Description" Text Width 20

Save file as schema.ini

*.csv file example:

No;Cartoon Name;Description

1.;Bluey;Cartoon Character 1

2.;Peppa Pig;Cartoon Character 2

3.;Gudetama;Cartoon Character 3

4.;Mofusand;Cartoon Character 4

5.;Elsa;Cartoon Character 5

6.;Anna;Cartoon Character 6

7.;Spongebob Squarepants;Cartoon Character 7

8.;Finn;Cartoon Character 8

9.;Jake;Cartoon Character 9

10.;Minions;Cartoon Character 10

11.;Lightning McQueen;Cartoon Character 11

12.;Paw Patrol Pups;Cartoon Character 12

13.;Ladybug;Cartoon Character 13

14.;Tom;Cartoon Character 14

15.;Jerry;Cartoon Character 15

16.;CocoMelon;Cartoon Character 16

Save file as CartoonCharacter.csv

Bibliography

CSV Format File In Microsoft Excel

CSV On The Web 1

Simple Exception Summary In CSV Format

Study About Microsoft Office 1