import Excel to postgreSQL

[nehashri]

hello
i have my data stored in different Ms Excell sheets. now I am planning to make a database of the data i have. but i m confused whether to use Postgresql or mySQL for the same. i had plans to import data directly to Ms Access but there is problem with my access for now so i have to think of other choises.

i wanted to know whether it is easy to convert excel sheets to postgre that is can i import excel to postgreSQL. if yes how can i go about
thanking u in advance
neha

[michaelb]

If you can dump your spread sheet into the ASCII delimited file you can use the Postgresql COPY command to load it into the database table.
You can also google for "migration to Postgresql"; you'll find some third-party tools (some of them are free or have a free trial period) that do data-pumping and can help you with migration.

[nehashri]

If you can dump your spread sheet into the ASCII delimited file you can use the Postgresql COPY command to load it into the database table.
You can also google for "migration to Postgresql"; you'll find some third-party tools (some of them are free or have a free trial period) that do data-pumping and can help you with migration.

thank you so much.......i am sure that will be of great help
neha

[varathasiva]

U can use the excel application through by coding u can excport data to postgres sql table to excel like verse visa

[coolminded]

U can use the excel application through by coding u can excport data to postgres sql table to excel like verse visa

can anyone be more specific or any link on how to export data from excel to postgresql database. i could not get varathasiva, what he wants to say

plz help

[varathasiva]

Here i enclosed my sample codings.If you need you can use the coding like in delphi programing

 var strFileName,cnt_str:string;
 flcid,cnt,scnt,i :integer;
 Temp_Worksheet : _WorkSheet;
begin
  if chk_ch then
    begin
     try
      ExcelApplication1.Disconnect;
     finally
    end;
    end;
    ExcelApplication1.Connect;
    ExcelApplication1.Visible[0]:=True;
     try
     ExcelWorkbook1.Disconnect;
    finally     end;
 
    ExcelWorkbook1.ConnectTo(ExcelApplication1.Workbooks.Add(EmptyParam,0));
 
    Temp_Worksheet:=ExcelWorkbook1.
    WorkSheets.Add(EmptyParam,EmptyParam,EmptyParam,EmptyParam,0) as _WorkSheet;
    ExcelWorkSheet1.ConnectTo(Temp_WorkSheet);

[ryjfgjl]

This tool will be very useful if you do not want to code
or you are not clear about pg:

Import excel into database automatically-ExcelToDatabase

[coldbluts]

i am sure that will be of great help