Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Best way / software/ language to Transform .xls, .csv, or .xml Data to


  • Please log in to reply

#1
Johnson36912

Johnson36912

    New Member

  • Member
  • Pip
  • 1 posts
Hi,
 
I'm looking for the Best way / software/ language to Transform .xls, .csv, or .xml Data to a Relational Format.
 
The main example is from http://www.thetakeov...isclosure-tablethey have options for .xls, .csv, or .xml 
 
I am wondering which one is best to store and load to raw (speed/ space/ etc.) and also which format is the best to transform to a Relational Format in any cloud DB.
 
Please let me know if you need any other details.
 
Best,
Pat

  • 0

Advertisements


#2
fjank

fjank

    New Member

  • Member
  • Pip
  • 7 posts

You could use any language to convert to SQL statements to push into a database,

you need to consider:

What database type are you going to store the data into?

You mention cloud DB, what kind of access do you want to this cloud DB, raw SQL? web SQL? something else?

What is the end user requirements?


  • 0

#3
debora32

debora32

    Member

  • Member
  • PipPip
  • 20 posts

Advanced XML Converter helps you convert XML to other database and document formats: HTML, CSV, DBF, XLS and SQL. As you upload XML file and click CONVERT, the program delivers high-quality output in a new format. To deliver correct output, the program uses the hierarchical structure of the XML source to extract data. Then users can select the data that they want to see in the output. Advanced XML Converter is able to handle large XML files and convert more than one XML file in one go. With Advanced XML Converter, you no longer need to write complex XML transformations or XSL style sheets. Convert XML to HTML, CSV, DBF, XLS, SQL cleanly and almost hands-down!

 

XML converter Key Features:

  • Convert XML to CSV (text file with comma-separated fields)
  • Convert XML to HTML table format (for Internet browsers)
  • Convert XML to DBF (for FoxPro, DBase)
  • Convert XML to XLS sheet (for Microsoft Excel)
  • Convert XML to SQL query (for most database SQL servers)
  • Extract data from XML files of any complexity in a snap
  • No need to write complex XML transformations or XSL Style sheets
  • No Java or .NET is required

  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP