客户已经将notes中的用户数据导出到文本文件中,这种文本的格式与SQLServer导出的格式很不一样啊,我该如何将这个文件导入到SQLServer数

secondlf 2003-10-10 11:56:47
Owner: CN=admindtf/OU=dtf/O=sxmcc/C=cn
Type: Person
Certificate: 03004102 D9D86808 13G0161F G002927A 276BF103 G0030200 01208600 9F402800 AF6C25G0 024FG002 A1402800 AE6C2500 70212800 35FE2548 01A07700 9F402800 AF6C25G0 024FG002 A1402800 AE6C2500 70212800 35FE2548 4F553D64 74662F4F 3D73786D 63632F43 3D636E43 4E3D6164 6D696E64 74662F4F 553D6474 662F4F3D 73786D63 632F433D 636E4256 0400312E 30004243 01000342 41010030 424C0200 76024E4E 4F006326 B4F97897 89588EA2 33359E35 35323F92 7E71FFE2 0035561F 6B545256 7020AACD EF766054 0F1E45C5 330A1428 EE672B5C BD0A2AD3 18A368BB 8666BA36 9D3ED3AA 42AB468A 888C8233 B5B2AAEC 36454E03 00010001 4D410800 FFFD5168 55FEEE25 7E005055 52534146 FCAFAB0D 99022CC4 7CBD95CB E0BC722F 4A5F5E1E 058E52D2 BDED8B88 DAB4C7C8 2F5FE9C3 001AF46E 29AF9981 3C2404BE B0B60F9E 1A4E45E9 9E184BFC 25A3F74D DEFBD9D6 7BC62F53 EE663048 2B641242 56040031 2E300042 43010003 42410100 30424C02 G001024E 4E4000A3 DEE61553 49E44783 AF959E98 E435A812 BC8B9C8F BD3BFF2C A915FABB 277F883E 51A1786A 46179960 EE4ECF06 1F88B8A0 334B4D55 57E1B8EE FD42CE82 7631B645 4E030001 00014D41 0800B9C6 A2C947DD F8086F00 50555253 4146724A EF4E5EAA 8928C720 ADF96011 FA76A17F B665017E 53F625F6 8D439F28 47F1FA71 BAC6391D 0DEFF360 AF6D13D4 6E9CD41D D63D0855 A7EA1D40 25AEE069 EE09AFDD A996A0A3 43201881 836E24A0 13
MailSystem: 1
$FILE:
ClientType: 0
Title:
Suffix:
MailAddress:
ccMailLocation:
InternetAddress:
MessageStorage: 1
EncryptIncomingMail: 0
Comment:
CalendarDomain:
WebSite:
AltFullNameSort:
PublicKey:
LocalAdmin:
Profiles:
CheckPassword: 0
AvailableForDirSync: 1
PasswordChangeInterval: 0
PasswordGracePeriod: 0
ProposedAltCommonName:
ProposedAltOrgUnit:
PasswordDigest:
ProposedAltFullNameLanguage:
DocumentAccess: [UserModifier]
OU:
PostalAddress:
HomePostalAddress:
Street:
FirstName:
MiddleInitial:
LastName: admindtf
FullName: CN=admindtf/OU=dtf/O=sxmcc/C=cn,admindtf
AltFullName:
AltFullNameLanguage:
ShortName: admindtf
HTTPPassword: (355E98E7C7B59BD810ED845AD0FD2FC4)
MailDomain: sxmcc
MailServer: CN=fgsom01/OU=servers/O=sxmcc/C=cn
MailFile: mail\admindtf
ccMailUserName:
x400Address:
NetUserName:
PasswordChangeDate:
SametimeServer:
$UpdatedBy: CN=admin/O=sxmcc/C=cn


Owner: CN=adminjcf/OU=jcf/O=sxmcc/C=cn
Type: Person
Certificate: 03004102 A5B61806 13G0161F G0029ADC 2C341603 G0030200 01208600 B7A92900 AF6C25G0 024FG002 B9A92900 AE6C2500 50502800 35FE2548 01A07700 B7A92900 AF6C25G0 024FG002 B9A92900 AE6C2500 50502800 35FE2548 4F553D6A 63662F4F 3D73786D 63632F43 3D636E43 4E3D6164 6D696E6A 63662F4F 553D6A63 662F4F3D 73786D63 632F433D 636E4256 0400312E 30004243 01000342 41010030 424C0200 76024E4E 4F0039C8 0A258696 60978D73 457CCE34 D0CBE7BF C1FEBB8E E7D96E3F 1786D1FF 75A88643 12A4458F 0AB10F0C 3A7C2BEE B9C2893C 92403E3B 257687DE 3C8DF77C D4C41C12 A98E52E9 119CF18A 1F9BEFF4 32454E03 00010001 4D410800 B81E8990 2608E433 7E005055 52534146 EECCDC35 F04B78FF E9F3EC78 BE4750D1 1909EB8A 6D06F568 FDCCBD15 934F08FC 5DBF642E EEEF42C8 4E589BA2 E84931FC 3F5FB0E4 4478B726 344E681C 61C14398 5D555DE3 5B689352 F745FCCA 92521442 56040031 2E300042 43010003 42410100 30424C02 G001024E 4E4000EF 1BB3045D DEF47D7F 3A00D489 781F2457 F0637A8A 5ED33997 FEF301FE B1C32D9A FD44BB29 C9613426 6413BB26 428AA95F 2F62A288 6FD78962 8021F799 2965F045 4E030001 00014D41 08005C67 2CB40928 69076F00 50555253 41460931 0A7B91FC 88EB55AC 34DB4411 AF289C91 783C7181 52AA4804 C6D4CBFC E337C3DC 0ED51574 F53DE612 E0D0DA57 7FA68545 94721A84 F4042F53 6D227FFD 9A0EFC48 F424FE51 31B9F649 DCDF7D08 19
MailSystem: 1
$FILE:
ClientType: 0
Title:
Suffix:
MailAddress:
ccMailLocation:
InternetAddress:
MessageStorage: 1
EncryptIncomingMail: 0
Comment:
CalendarDomain:
WebSite:
AltFullNameSort:
PublicKey:
LocalAdmin:
Profiles:
CheckPassword: 0
AvailableForDirSync: 1
PasswordChangeInterval: 0
PasswordGracePeriod: 0
ProposedAltCommonName:
ProposedAltOrgUnit:
PasswordDigest:
ProposedAltFullNameLanguage:
DocumentAccess: [UserModifier]
OU:
PostalAddress:
HomePostalAddress:
Street:
FirstName:
MiddleInitial:
LastName: adminjcf
FullName: CN=adminjcf/OU=jcf/O=sxmcc/C=cn,adminjcf
AltFullName:
AltFullNameLanguage:
ShortName: adminjcf
HTTPPassword: (355E98E7C7B59BD810ED845AD0FD2FC4)
MailDomain: sxmcc
MailServer: CN=fgsom01/OU=servers/O=sxmcc/C=cn
MailFile: mail\adminjcf
ccMailUserName:
x400Address:
NetUserName:
PasswordChangeDate:
SametimeServer:
$UpdatedBy: CN=admin/O=sxmcc/C=cn


Owner: CN=adminjwf/OU=jwf/O=sxmcc/C=cn
Type: Person
Certificate: 03004102 648258C2 13G0161F G00214FD A1A6A403 G0030200 01208600 B0D72900 AF6C25G0 024FG002 B2D72900 AE6C2500 60BC2900 35FE2548 01A07700 B0D72900 AF6C25G0 024FG002 B2D72900 AE6C2500 60BC2900 35FE2548 4F553D6A 77662F4F 3D73786D 63632F43 3D636E43 4E3D6164 6D696E6A 77662F4F 553D6A77 662F4F3D 73786D63 632F433D 636E4256 0400312E 30004243 01000342 41010030 424C0200 76024E4E 4F00B98D C284A573 82E28FA6 29EA1052 2C724DD2 176163A2 5D3FD46A BDB5CA6B 5390726F 36B71439 5260A9AB 9D2672AA A26468E3 FE3CC670 E7D0137F 5E76954A 7200734B C5B5470B 1A5B8B13 82207D7D 2A454E03 00010001 4D410800 79B12E18 BCD0C076 7E005055 52534146 D1C99B72 95CE53AD 0CE5B813 FAF79528 D9DB9C24 1F8A266E DD0C9E80 EC607920 4CA28F46 8734F3B2 86D56E26 FDE1AD38 F0579861 7E6D8069 F3C6F77C D1DD4EA3 9D53553C DD60AEA5 D2962B09 77972E42 56040031 2E300042 43010003 42410100 30424C02 G001024E 4E4000F9 FD22E58A 887E6686 E8DF5E65 D5B6AF7F A2E46D65 847EF70E 83977217 485C6650 72CDD151 DE25B9E8 B4790811 7D76DED8 D45151A5 E4145741 6E46D7C3 2063B745 4E030001 00014D41 0800DCE5 D95113C8 191B6F00 50555253 4146C6FE BE4791FC 1D38A05C C46DAC84 7156B46D 73B1B7F2 226A8DFE 4A5E73E5 9CE30005 330326CE 87D3A8D1 348EF82F 670DE03A 9B822782 0D5343C4 8CD8D0FC 3D98D3BF CB1E1829 4A46F832 E3452691 2F
MailSystem: 1
$FILE:
ClientType: 0
Title:
Suffix:
MailAddress:
ccMailLocation:
InternetAddress:
MessageStorage: 1
EncryptIncomingMail: 0
Comment:
CalendarDomain:
WebSite: ................................

有什么好办法吗???急急急
...全文
110 3 打赏 收藏 转发到动态 举报
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
pbsql 2003-10-10
  • 打赏
  • 举报
回复
让他按你要的格式导出
zjcxc 元老 2003-10-10
  • 打赏
  • 举报
回复
程序中代码好啦.
leus 2003-10-10
  • 打赏
  • 举报
回复
写段代码转一下格式就好了呀
要开饭了,下午回来写

34,593

社区成员

发帖
与我相关
我的任务
社区描述
MS-SQL Server相关内容讨论专区
社区管理员
  • 基础类社区
  • 二月十六
  • 卖水果的net
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧