POI's application for Garmin

[Cloggy]

I made a little application which maintains POI's for my Garmin (it features
a lot more than any other stuff, direct links into Google maps, etc. Real
proud of myself here). This only issue I have is that when I export to *.csv
(required for Garmin) I loose some digits from the Longitude & Latitude (it
only keeps 2 decimals), which places the POI in the incorrect place as some
degrees have up to 10chrs after the -.-

e.g.
FixedSpeedCam 100km/h
Lat: 53.8588546936266
Long: -6.40039443969727
....becomes
Lat: 53.85
Long: -6.40

Currrently I export as *.xls and convert that into *csv, but there must be a
way to do this direct from access.
Googled for the last 2 days with no result...

Thx for your help.
Cloggy

 

[Paul Shapiro]

You could try exporting from a query where you convert the numeric lat/long
into strings with the format function so you can specify the number of
decimal points. Or you could do it all in VBA: create the file and loop
through your recordset writing each row to the file. I think you can also
use an export specification to control the format, but I haven't looked at
that in a while so I'm not sure it has that capability.