Home » Creating POI files

EXCEL error line 883

 
Thu, 01/04/2007 - 7:00pm

OK
When people up-load my Paintball file, and use POI Loader to install it. They ALL get a Error message that says something like
Error line 773

They hit OK
and the file loads properly, and works.

BUT WHY THE ERROR MESSAGE.

Anything I can do to get rid of that error message??

‹ SORTING IN EXEL ?? Creating POI's ›
--
TRACY
Thu, 01/04/2007 - 7:42pm

extra quotation marks " "

Tracy,

I would open the file in Word Pad and look on
line 773 for extra quotation marks " "
I found this to be the case with my Charlotte
NightLife .csv file. What had happen was that for
some odd reason Excel had put in an additional set
of quotation marks on each side of the address on column 4
line 25

example: ""214 North Tryon Street
Charlotte, NC 28202""

This is why I was getting the error.
I took the extra " off and it fixed
the issue.

Hope this helps.

--
Orbital
Thu, 01/04/2007 - 9:01pm

THAT FIXED IT

I told EXCEL to find all " and replaced them with a blank space.
It worked.

File now loads correctly.

I put the corrected the file on the site.

--
TRACY
Thu, 01/04/2007 - 9:07pm

neat trick

thanks tracy, I use that trick too:)