import Excel to postgreSQL

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

Subscribe Post Reply

35130

michaelb

534

Expert 512MB

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

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

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

100+

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

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

Expand|Select|Wrap|Line Numbers

 
 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);

May 30 '07 #6

ryjfgjl

Nibble

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

4 Weeks Ago #7

coldbluts

2Bits

i am sure that will be of great help

2 Weeks Ago #8

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...

DB2 Database

Plez help quick - people waiting - IMPORT problem with A2K-Excel

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...

Microsoft Access / VBA

import excel with macro and truncate 1000s off of time

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...

Microsoft Access / VBA

#import library - objects are not recognized

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...

.NET Framework

Export and Import from Excel into a Web page

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 =...

ASP.NET

RAD with postgreSQL

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...

PostgreSQL Database

Import an Excel table to a Postgresql one

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...

PostgreSQL Database

Mass Import/Generate PKs

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...

PostgreSQL Database

Import Excel data with .NET

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...

C# / C Sharp

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

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,...

General

The easy way to turn off automatic updates for Windows 10/11

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...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

AI Job Threat for Devs

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,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

Couldn’t get equations in html when convert word .docx file to html file in C#.

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...

C# / C Sharp

Similar topics