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






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