On 01/09/07, Ashish Karalkar <ashish.karalkar@xxxxxxxxxxxxxxxxx> wrote: > > > Hello All, > I want to export data from PostgreSQL tables to MS Excel. > Is there any way? Sure, write SQL in a program (php, perl, jsp, asp) to dump the tables in HTML <table><tr><td> rows format. Then import that HTML page program into Excel from Tools --> Data Sources. Once you save the xls file, you can always just refresh the data because it already points to your program. I guess there must be other ways, but this one works fine for me. Excel has a limit of 65,700 rows (or thereabouts) so it's not a huge deal for a db like pgsql. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
