Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to load a file with data that looks like the attached "sample data.csv" file.
I am using the following script (Createdwith the Table Files... option) to load the file.
LOAD [Inventory Number],
ID,
[Location Name],
[Local Calls ],
[National Calls ],
[Int'l Calls ],
[Special Calls ],
[National Mobile Calls ],
[Int'l Mobile Calls ],
[Incoming Calls ],
[Total Calls],
[Local Minutes ],
[National Minutes ],
[Int'l Minutes ],
[Special Minutes ],
[National Mobile Minutes ],
[Int'l Mobile Minutes ],
[Incoming Minutes ],
[Total Minutes],
[Local Cost ],
[National Cost ],
[Int'l Cost ],
[Special Cost ],
[National Mobile Cost ],
[Int'l Mobile Cost ],
[Incoming Cost ],
[Total Cost],
[LE-OU],
[REASON FOR ERROR]
FROM
C:\Downloads\sample data.csv
(txt, codepage is 1252, embedded labels, delimiter is ',', header is 4 lines);
When I try to do a reload I get the following error.
(txt, codepage is 1252, embedded labels, delimiter is ',', header is 4 lines)
Any ideas on how to solve this error?
I think because of field name
replace
with
[Local Calls],
and the samefor other fields
View solution in original post
This worked! Thank you very much.
