> I am relatively new to PostgreSQL, having only been exposed to it with
> a recent DSpace implementation (in the last 8 months or so). I have created
> a new database in PostgreSQL and have written a SQL query against the
> database. The database resides on a Sunfire V440 Solaris 9 machine. I need
> to figure out how to either create an icon on a User's desktop on a Windows
> machine that invokes and runs the SQL query, or - if that can't be done -
> create a script they can execute to accomplish the same thing. The script
> will need to allow the Users to input some parameters which will be passed
> to the SQL query (Begin Date, End Date, etc) and will then execute the query
> write the output to a file and then invoke a Excel spreadsheet macro to
> pull the data into the Excel spreadsheet and format it.
>
> Is this possible or am I on the wrong track?? Any suggestions or help
> would certainly be appreciated. If there's a better way to accomplish this,
> I'd love to hear it. :-)
Why not run the entire query directly from excel directly. All you will need to do is install the
postgresql ODBC driver on each windows machine. Then in excel you can put your query that will be
passed to the server using ODBC. The results will be populated in the excel spreadsheet.
http://pgfoundry.org/projects/psqlodbc/
this was the first result from googling excel and odbc, but it illustrates to procedure well.
http://www.datamystic.com/datapipe/excel_odbc.html
Regards,
Richard Broersma Jr.