Exporting table to DBF and number of decimal spaces
Posted on 2003-10-31
I have this code (below) that works fine with one exception. In my table I have a field set as Double with 9 decimal spaces. When I export the table to DBF it only gives the field 5 decimal places. Anyway to force it to give 9?
Private Sub ExportWebSponsorsGeocodecmd_Click()
On Error GoTo Err_ExportWebSponsorsGeocodecmd_Click
DoCmd.TransferDatabase acExport, "dBase III", "\\Clustertor1\storage\SponsorDatabase\GeoCode\", acTable, _
"tbl_Combined_All_Sponsors", Format(Now(), "mmddyy") & "_GeoCode.dbf"
MsgBox "File Exported for Geocoding", vbOKOnly, "Finished"