Hello everyone,
apologies for the delay in providing the sum of replies but this
project got put on the backburner and I have only just got back to it.
My original question was as follows:
> We are using MapInfo's BS7666 Toolkit to produce a land and property
> gazetteer and this uses an access database linked to mapinfo.
>
> The problem I have is that I am about to receive a file containing and
> updated NSG (National Street Gazetteer) and I need to replace the existing
> tables with the new ones. The toolkit does not have an update import
> routine
> so I will load the data into a seperate data base and then hopefully
> replace
> the relevant tables (in a copy of the original database of course!).
>
> This is where I need some help, some of the tables have very long numbers
> (e.g. 465,220,100,407) and access shows them like this '4.65220100407E+11'
> .
> How can I do this with out loosing data. Can I do this through mapinfo and
> refresh the odbc or is it better to do it in Access.
David Andrews gave the following detailed reply, which was very useful.
Thanks David
You might be better off importing the records into a new table in the
Access database, then just doing a query to select the new records then
doing an append query to the existing STREET table.
Do you have graphics for the new street already, will you be using
OSCAR? or will you digitise them yourself?
Another option is to do a completely fresh import into the toolkit into a
totally new project with the updated NSG and OSCAR then transferring the
new STREET, ESU & ESU COORD tables back into your existing project. If
you do this don't delete the tables and then import the new tables as
this will break all your relationships in Access.
Depending on the number of streets and how you are going to enter the
graphics will influence which one method to use? If only a few streets
then I would choose the first option, if many then probably the second.
Regarding Access and displaying fields.
I assume that the numbers you need to display are ESU ids. In order to
get them to display as you wish set the field size to Double and the
format to '000000000000' for the ESU_ID column of the ESU table.
This has to be done in Access, as does any database work for the
Toolkit. The Toolkit reads the data directly through an Delphi ADO
connection. It cant be done in MapInfo.
Jonathon Stokes & Douglas Cubin suggested that I change the column from
integer to chr$ on import, unfortunately the column has to be numerical.
Thank you again to everyone who helps lightweights like me out. It is
greatly appreciated.
Regards
Malcolm Norman
GIS Development
Engineering & Design Services
Tel: (9284) 1603
**********************************************************************
This footnote confirms that this email message has been swept
for the presence of computer viruses and none were found.
Portsmouth City Council. IT Services
(New Rich Outgoing))
**********************************************************************
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
