GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
IMport data to MS SQL Server 2005  XML
Forum Index -> General
Author Message
pprao



Joined: 17/11/2007 04:46:57
Messages: 1
Offline

Does anyone know how to import this data to MS SQL Server 2005.

I tried to use DTS, but it dont seem to understand utf-8 files. Any suggestions??

marc



Joined: 08/12/2005 07:39:47
Messages: 3993
Offline

There is a link to a howto in this thread :
http://forum.geonames.org/gforum/posts/list/146.page

Marc

[WWW]
junto



Joined: 20/12/2007 14:56:01
Messages: 3
Offline

I found it much easier to import it into SQL2000 first then DTS copy across to SQL2005. To be honest, I find the new DTS in SQL2005 a nightmare. It is so picky.
 
Forum Index -> General
Go to:   
Powered by JForum 2.1.5 © JForum Team