Converting .dbf database files to .ov2 files

[nickburt]

Has anyone had any success converting .dbf database files, to .ov2 files to import POIs ?
I can get the dbf file into excel, and therefore into .csv files etc..., but when I try using any of the converters to get from OS grid refs, to lat / long or northing / easting I have an invalid format problem.
If I can get over this, I'd then convert using makeov2.

Cheers,
Nick.

[Oldboy]

In a .ov2 file there are 3 fields only per record.

The .csv file, (.asc or .txt also works) needs to be in this format.

Long, Lat, Text.
-0.12345, 52,12345,"Any old text".

Don't put the quote (") marks into Excel as this will generate multiple quotes.

I find it better to add them later, into the text file, using Find/Replace. I use Word for that.
_________________
Richard

TT 910 V7.903: Europe Map v1045
TT Via 135 App 12.075: Europe Map v1120

[Oldie]

We see you’re using an ad-blocker. We’re fine with that and won’t stop you visiting the site.
Have you considered making a donation towards website running costs?.
Or you could disable your ad-blocker for this site. We think you’ll find our adverts are not overbearing!