calling data from a database using vba

[GreenyMcDuff]

Morning all,

I am starting a new project involving vba and a postgreSQL database.

Quick question to get the ball rolling... is it possible to link the postgreSQL database via vba to excel 2007??

If so, how does this process work? The data needs to be manipulated, so in my head the process works according to the following steps:

1. data is stored in database
2. vba macro access's the database
3. data is imported to excel
4. vba macro used to manipulate data.

Does any of this sound do-able?

Kind Regards

Chris

 

[Gary McMaster]

Hi Chris,

It is entirely possible. Here is some info from Microsoft:

http://office.microsoft.com/en-us/e...ry-to-retrieve-external-data-HA010099664.aspx

If an ODBC driver for your database has already been installed you should be able to connect to your database in a matter of minutes using the "Query Wizard". If the driver has not been installed then check the database vendors website or the CDs that came with your DB package for the driver and installation instructions.

Once you are able to connect via the Excel "Query Wizard" you can record a macro while accessing a database table with the Wizard. That will give you a good head start on the VBA code you will need.

Gary

 

[GreenyMcDuff]

Hi Gary,

Thanks for the info. Much appreciated

Chris