473,573 Members | 2,558 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

import Excel to postgreSQL

nehashri
49 New Member
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
7 37608
michaelb
534 Recognized Expert Contributor
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
49 New Member
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
varathasiva
20 New Member
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
coolminded
137 New Member
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
varathasiva
20 New Member
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
ryjfgjl
9 New Member
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
Mar 29 '24 #7
coldbluts
2 New Member
i am sure that will be of great help
Apr 11 '24 #8

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

Similar topics

1
1853
by: Ugrasena via DBMonster.com | last post by:
Hi team Is there any easy way to Import PostGRESQL 7.2 which is on the Linux mechine to a DB2 UDB 7.2 on WIndows. What Options do i have. Thanks Ugra -- Message posted via http://www.dbmonster.com
1
3192
by: Richard Holliingsworth | last post by:
Hello: Thanks for your quick response. I'm trying to import a new Excel file into an A2K table and it's truncating the data. One of the Excel columns is a text field that can be up to 2000 characters. When I import it into A2K, that field is truncated. If I try to inport the file into an EXISTING table that I define myself where that...
8
6544
by: Nick M | last post by:
Hello All, Excellent info here Thanks! I am very new to using access in general and I am on a learning curve. I'm trying to import an excel workbook (with worksheets) into an access db via a macro. (I'll get to using VB later on). What I would like to do is import a single workbook w/three seperate worksheets into three seperate access...
0
1422
by: autoEx | last post by:
I am using #import directive to import the excel library to make excel files but the excel object is not recognized by my application. Here is what I do: I have simple dialog based MFC application in VC 6.00 In the dialog .cpp file, I add the following #import "D:\\Program Files\\Microsoft Office\\Office\\MSO9.DLL" no_namespac #import...
2
3982
by: Siu | last post by:
Hi, I use the following code to export and import a file Excel from resp. into a Web page with the following code: //EXPORT Response.Clear(); Response.Buffer = true; Response.ContentType = "application/vnd.ms-excel"; Response.Charset = ""; this.EnableViewState = false;
7
3680
by: Eric | last post by:
Hi, Any suggestion to Rapid Application Dev with postgreSQL ? I have a small app to make. I would prefer open-source solution if possible. I also would like to developp on my linux box but the result will be used on a windows 2000 and XP machine. But If I have no choice, I will developp on winXP.
2
2420
by: Daniele Beauquier | last post by:
How to import an Excel table into a Postgresql table in a simple way? ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
5
3804
by: Hunter Hillegas | last post by:
I have a CSV file with 400,000 lines of email mailing list information that I need to migrate to a new PostgreSQL database. Each line has all the info I need except a PK (I usually use an int4 column for a PK). If the file were smaller I would probably just use Excel to pop in a PK and then just load into the table... Since Excel...
10
11805
by: Niklas | last post by:
Hi Before I start coding I need to be sure that nobody else has not done it yet and that I can use it. I need an import utility which import data from Excel to a database or some object in .NET. The data in Excel is not in structured columns but can exist everywhere in the workbook. For example if I am supposed to import a person and all...
0
7750
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7674
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8182
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7744
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8039
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5559
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5271
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3708
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3708
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.