473,517 Members | 2,758 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 37303
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
4 Weeks Ago #8

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

Similar topics

1
1839
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
3174
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
6539
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
1411
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
3974
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
3664
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
2408
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
3795
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
11793
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
7190
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
7423
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7153
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
7554
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...
0
5730
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
4781
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
3276
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
3272
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
501
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.