Hi,
I've had to do this several times.
So far I've found no simple answer/way.
This is how I do it.
a) export excel file to tab seperated file.
b) Import complete csv/text file into a table using copy. ( Eg. temp_table )
c) Select from that temp table into new tables to build the new database.
Here's and example script:
INSERT INTO grounds
(
gt_id,
reg_id,
g_name,
g_address1,
g_country,
g_phone,
g_fax,
g_email,
g_url,
g_notes,
g_activities,
g_username,
g_pwd
)
SELECT
1,
1,
name,
location,
'Australia',
phone,
fax,
email_address,
domain_name,
notes,
activities,
'username',
'pwd'
FROM import_temp;
Sometimes SQL is not enough and I use scripts written in PHP or Perl or ColdFusion.
I save all my import scripts. eg. import01.sql, import02.sql, import03.php, so that I can easily reuse them.
Hope this brief response helps.
Cheers
Rudi.
Devi Munandar wrote:
Dear Admin,
Same Problem with Mr.Sidar Lopez Cruz too,but I want to Migration my data from microsoft Excel to Postgresql, there are any possible to Migration..???
best regard,
-devi munandar
----- Original Message -----
Sent: Tuesday, July 08, 2003 12:44 AM
Subject: [ADMIN] exporting data
which is the best tool for exporting data from mssql to postgresql
i try with pgAdmin II, but it's slow
i try directly by odbc from mssql but don't work
:-) Sidar Lopez Cruz
- Cero Riesgo, S.A.