By annu_singh on

Hi,

I am new to drupal. I have to an excel sheet in which data are there. I have to putthat excel data into my sql tables .Is there any module in drupal to do it. If not then how should i do it in drupal.

Thanks,
Annu

⋅ Categories: Drupal 5.x

Comments

cog.rusty’s picture

cog.rusty commented

It is unlikely to find a Drupal module, because that doesn't have much to do with Drupal, except if you are talking about data which correspond to one of Drupal's data structures (for example, Drupal user account data).

First, you will need to create a database table with the proper data types to hold your data. Then, you can save your Excel spreadsheet as a comma separated list (a .csv file) and import it to your database.

Generally, phpmyadmin is the tool which you need for both of these steps. For more details, google import csv mysql phpmyadmin.

nevets’s picture

nevets commented

Another approach if the data can be stored as nodes is to create a content type with the necessary fields and use the node import module.

annu_singh’s picture

annu_singh commented

Hi,

Actually what i have to do is that i have a order_master table of my own. not of drupal. What I have to do is that i have download the data of the table in quickbook format. Quickbook is an accounting s/w popularly used in USA.

I need help on this matter.

Thanks,

Annu

MidGe48’s picture

MidGe48 commented

Annu,

I think the previous poster is quite right. If your data is tabular and each row contains one order data. Then importing it via Node import module, where each order becomes a node, will alow you to use the Views module for some reasonably flexible table presentation of that data.

You could even do it quite easily, just a bit more complicated, it with multiple lines per orders. Beyond that you may have to use some programme skills as far as I know.

www.ZuNOB.com

Joker-TR’s picture

Joker-TR commented

you can use some software for this...
I think Full Convert is enough for you...

http://www.spectralcore.com/fullconvert/index.php