将分隔文本文件转换为XML [英] Converting Delimited Text File into XML

问题描述

您好


我想将一个巨大的分隔文本文件（大约85MB）直接转换为XML。我不想循环文本文件并写为xml，因为它是一个非常大的文件，并花了很多时间。可以任何人帮助我，如何转换


提前感谢您的帮助


最佳Rgds

Padmaja。

解决方案

鉴于您可以访问可以返回XML结果集的数据库，您可能需要
尝试将csv导入临时表，然后查询输出为XML的

表。


" Padmaja" <一个******* @ discussions.microsoft.com>在消息中写道

新闻：F2 ********************************** @ microsof t.com ...

您好，
我想将一个巨大的分隔文本文件（大约85MB）直接转换为
XML。我不想循环遍历文本文件并写为xml，因为它是非常大的文件并花费很多时间。任何人都可以帮助我，如何转换？
在此先感谢您的帮助。

最好的Rgds，
Padmaja。

谢谢solex，你能告诉我如何将csv转换为temp。桌子


Rgds

Padmaj


----- solex写道：----


鉴于您可以访问可以返回XML结果集的数据库，哟

可能想尝试将csv导入临时表，然后查询

表格输出是XML


" Padmaja" <一个******* @ discussions.microsoft.com>在消息中写道

新闻：F2 ********************************** @ microsof t.com ..

Hello

我想直接转换一个巨大的分隔文本文件（大约85MB）int
XML。我不想循环遍历文本文件并写为xml，因为它是一个非常大的文件并花费了很多时间。任何人都可以帮助我，如何转换感谢您提前获得所有帮助
最佳Rgds

Padmaja

Padmaja，


不幸的是，这完全取决于您的数据库。例如SQL服务器

支持XML，但MS Access不支持，如果你有SQL服务器，你可能需要

来做一些关于XML的研究并导入或检查一些SQL服务器

新闻组。此外，我通过谷歌找到了这个资源，这可能有所帮助：

http://weblogs.asp.net/kaevans/archi...4/17/5780.aspx


For其他资源检查：
http://www.google.com/search?q=CSV+t...utf-8&oe=utf-8


问候，

Dan


" Padmaja" <一个******* @ discussions.microsoft.com>在消息中写道

news：74 ********************************** @ microsof t.com ...

谢谢solex，你能告诉我如何将csv转换成temp。桌子？

Rgds，
Padmaja

----- solex写道：-----

鉴于你有访问可以返回
XML中的结果集的数据库，您可能希望尝试将csv导入临时表，然后
查询输出为XML的表。
Padmaja <一个******* @ discussions.microsoft.com>在消息中写道
新闻：F2 ********************************** @ microsof t.com。 ..

>您好，

>>我想将一个巨大的分隔文本文件（大约85MB）
直接转换为

XML。我不想循环遍历文本文件并写为xml，因为
它是非常大的文件并且花费了很多时间。任何人都可以帮助我，如何

转换？ >>在此先感谢您的帮助。
>>最好的Rgds，

> Padmaja。

Hello

I want to convert a huge delimited text file (of appr 85MB) directly into XML. I dont want to loop through the text file and write as xml, as it is very large file and taking much time. Can any one help me, how to convert

Thanks in advance for all your help

Best Rgds
Padmaja.

解决方案

Given that you have access to a db that can return result sets in XML, you
might want to try to import the csv to a temporary table and then query the
table whos output is XML.

"Padmaja" <an*******@discussions.microsoft.com> wrote in message
news:F2**********************************@microsof t.com...

Hello,

I want to convert a huge delimited text file (of appr 85MB) directly into XML. I dont want to loop through the text file and write as xml, as it is
very large file and taking much time. Can any one help me, how to convert ?
Thanks in advance for all your help.

Best Rgds,
Padmaja.

Thanks solex, can you tell me how to convert csv to a temp. table

Rgds
Padmaj

----- solex wrote: ----

Given that you have access to a db that can return result sets in XML, yo
might want to try to import the csv to a temporary table and then query th
table whos output is XML

"Padmaja" <an*******@discussions.microsoft.com> wrote in messag
news:F2**********************************@microsof t.com..

Hello

I want to convert a huge delimited text file (of appr 85MB) directly int XML. I dont want to loop through the text file and write as xml, as it i
very large file and taking much time. Can any one help me, how to convert Thanks in advance for all your help
Best Rgds

Padmaja

Padmaja,

Unfortunately this all depends upon your database. For instance SQL server
supports XML but MS Access does not, if you have SQL server you might want
to do some research on XML and importing or check some of the SQL Server
news groups. In addition I found this resource via google which may help:

http://weblogs.asp.net/kaevans/archi...4/17/5780.aspx

For others resources check:
http://www.google.com/search?q=CSV+t...utf-8&oe=utf-8

Regards,
Dan

"Padmaja" <an*******@discussions.microsoft.com> wrote in message
news:74**********************************@microsof t.com...

Thanks solex, can you tell me how to convert csv to a temp. table?

Rgds,
Padmaja

----- solex wrote: -----

Given that you have access to a db that can return result sets in XML, you might want to try to import the csv to a temporary table and then query the table whos output is XML.

"Padmaja" <an*******@discussions.microsoft.com> wrote in message
news:F2**********************************@microsof t.com...

> Hello,

>> I want to convert a huge delimited text file (of appr 85MB) directly into

XML. I dont want to loop through the text file and write as xml, as it is very large file and taking much time. Can any one help me, how to

convert ? >> Thanks in advance for all your help.
>> Best Rgds,

> Padmaja.

这篇关于将分隔文本文件转换为XML的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！