By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,118 Members | 1,133 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,118 IT Pros & Developers. It's quick & easy.

import Excel to postgreSQL

nehashri
P: 49
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
May 14 '07 #1
Share this Question
Share on Google+
5 Replies


Expert 100+
P: 534
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.
May 14 '07 #2

nehashri
P: 49
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
May 15 '07 #3

P: 20
U can use the excel application through by coding u can excport data to postgres sql table to excel like verse visa
May 28 '07 #4

100+
P: 138
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
May 30 '07 #5

P: 20
Here i enclosed my sample codings.If you need you can use the coding like in delphi programing
Expand|Select|Wrap|Line Numbers
  1.  var strFileName,cnt_str:string;
  2.  flcid,cnt,scnt,i :integer;
  3.  Temp_Worksheet : _WorkSheet;
  4. begin
  5.   if chk_ch then
  6.     begin
  7.      try
  8.       ExcelApplication1.Disconnect;
  9.      finally
  10.     end;
  11.     end;
  12.     ExcelApplication1.Connect;
  13.     ExcelApplication1.Visible[0]:=True;
  14.      try
  15.      ExcelWorkbook1.Disconnect;
  16.     finally     end;
  17.  
  18.     ExcelWorkbook1.ConnectTo(ExcelApplication1.Workbooks.Add(EmptyParam,0));
  19.  
  20.     Temp_Worksheet:=ExcelWorkbook1.
  21.     WorkSheets.Add(EmptyParam,EmptyParam,EmptyParam,EmptyParam,0) as _WorkSheet;
  22.     ExcelWorkSheet1.ConnectTo(Temp_WorkSheet);
May 30 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.