On 01/09/07, Ashish Karalkar <ashish.karalkar@info-spectrum.com> 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.