导入步骤参考百度 https://jingyan.baidu.com/article/86fae346148ec53c49121a19.html
如果报 未在本地计算机上注册“Microsoft.ACE.OLEDB.12.0”提供程序 错误,需要安装Microsoft Access数据库引擎
安装包地址:https://www.microsoft.com/en-us/download/details.aspx?id=13255
安装完之后导入数据成功
接下来就是从自动生成的表中取出需要的字段放到需要的表中
我数据库中建的是area表,id,areatype,areacode,areaname,parentid
往area表中插入数据sql语句
insert into [avatar].[dbo].[Area](AreaType,AreaCode,AreaName,ParentId)
select '0',[省级编码],[省级名称],'0' from [avatar].[dbo].[Township_Area_A___副本] group by [省级编码],[省级名称] order by [省级编码]
insert into [avatar].[dbo].[Area](AreaType,AreaCode,AreaName,ParentId)
select '1', b.[市级编码],b.[市级名称],a.[Id] from [avatar].[dbo].[Township_Area_A___副本] b left join [avatar].[dbo].[Area] a on b.[省级编码]=a.[AreaCode] group by a.[Id],b.[市级编码],b.[市级名称]
insert into [avatar].[dbo].[Area](AreaType,AreaCode,AreaName,ParentId)
select '2',b.[区县编码],b.[区县名称], a.[Id] from [avatar].[dbo].[Township_Area_A___副本] b left join [avatar].[dbo].[Area] a on b.[市级编码]=a.[AreaCode] and a.[AreaType]='1' group by a.[Id],b.[区县编码],b.[区县名称]
insert into [avatar].[dbo].[Area](AreaType,AreaCode,AreaName,ParentId)
select '3',b.[街道乡镇编码],b.[街道乡镇名称],a.[Id] from [avatar].[dbo].[Township_Area_A___副本] b left join [avatar].[dbo].[Area] a on b.[区县编码]=a.[AreaCode] and a.[AreaType]='2' group by a.[Id],b.[街道乡镇编码],b.[街道乡镇名称]