XML File into a SQL table

AMP

I have a XLM file that contains data, but no schema, How can I read
this data into a SQL table (this has the correct colums etc

Dec 6 '06 #1

Subscribe Post Reply

838

rowe_newsgroups

XLM

I guessing you mean XML

One way would be to parse it manually with the XmlReader or XmlDocument
classes and then hit your table with SQL Insert commands.

Let me know if you need me to elaborate

Thanks,

Seth Rowe
AMP wrote:

I have a XLM file that contains data, but no schema, How can I read
this data into a SQL table (this has the correct colums etc

Dec 6 '06 #2

zacks

rowe_newsgroups wrote:

XLM

I guessing you mean XML

One way would be to parse it manually with the XmlReader or XmlDocument
classes and then hit your table with SQL Insert commands.

Let me know if you need me to elaborate

I wonder why anyone would go to such trouble with XMLSerialization is
so easy to use?

>
Thanks,

Seth Rowe
AMP wrote:
I have a XLM file that contains data, but no schema, How can I read
this data into a SQL table (this has the correct colums etc

Dec 6 '06 #3

rowe_newsgroups

I wonder why anyone would go to such trouble with XMLSerialization is

so easy to use?

When the OP said "contains data, but no schema" I took that as meaning
it wouldn't deserialize properly. Besides, depending on that how the
XML file is structured, a few well built for loops could run through
the file fairly easily.

Oh well, I guess there's more than one way to skin a cat :-)

Thanks,

Seth Rowe
za***@construction-imaging.com wrote:

rowe_newsgroups wrote:

XLM
I guessing you mean XML

One way would be to parse it manually with the XmlReader or XmlDocument
classes and then hit your table with SQL Insert commands.

Let me know if you need me to elaborate

I wonder why anyone would go to such trouble with XMLSerialization is
so easy to use?

Thanks,

Seth Rowe
AMP wrote:
I have a XLM file that contains data, but no schema, How can I read
this data into a SQL table (this has the correct colums etc

Dec 6 '06 #4

by: Dave Smithz | last post by:

Hi There, I have a PHP script that sends an email with attachment and works great when provided the path to the file to send. However this file needs to be on the same server as the script. ...

PHP

"XHTML file" cannot be identified by nokia 66

by: mike | last post by:

regards: I use Jtidy (api) to translate a HTML file into a "XHTML file". But The "XHTML file" cannot be identified by nokia 6600. Do I miss something important? Or this is Jtidy's weakness or...

.NET Framework

Need help with my code reading flat file into HTML table

by: JackM | last post by:

I need a little guidance putting a script together. I'm trying to read a list of image links from a text file (not a database) and display them in a table on my page. I want to display them in rows...

PHP

Loading a file into a TABLE

by: spwpreston | last post by:

Hello, I am new to MySQL. I am trying to load from a text file to a table, and am having problems with the fields in the text file being translated to the correct fields in the TABLE. Right...

MySQL Database

getting the value from text file to xml

by: Jerry John | last post by:

I am working in ASP.NET with C#. I have a text file which contains datas with delimiters. For example:- MSH|^~\$|DISCHARGE|CLAY COUNTY MEMORIAL|||200502110939| I also have an XML file created...

.NET Framework

Key Required for .Update with mdb file ? Assuming True

by: Miro | last post by:

I will ask the question first then fumble thru trying to explain myself so i dont waste too much of your time. Question / Statement - Every mdb table needs a PrimaryKey ( or maybe an index - i...

Visual Basic .NET

Reading file from Client instead of Server

by: SAL | last post by:

Hello, Is it possible to read a CSV from the Client, and bind my Datagrid to the data in the CSV file without uploading the file to the Server first? I have tried and in Debug mode on my...

ASP.NET

Save to file after sorting

by: ^cypis^ vel. SQ9JTI | last post by:

Hi there, i have a problem. I prepared bucket sorting with reading values from file (data.txt) and saving to other file (aus.txt). Everything is good if we talk about reading and sorting, but...

C / C++

The BEST "FREE" Pure ASP 10MB File Upload

by: hotflash | last post by:

Hi All, I found the best pure ASP code to upload a file to either server and/or MS Access Database. It works fine for me however, there is one thing that I don't like and have tried to fix but...

ASP / Active Server Pages

Upload photo in asp.net content page

by: premprakashbhati | last post by:

hi, good evening.. i am going to upload an image in a web form .....for that iam using HTML input(file) control and one web control button i.e., Upload_Button() here is the code ...its work fine...

ASP.NET

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

Similar topics