export data from MS Excel sheet to external database
 

Hello,

I'd like to export data from MS Excel sheet to external PostreSQL
database. If anyone has experience in solving such a problem - please
tell me :)

Thanks in advance for reply,
Mariusz

export data from MS Excel sheet to external database
 

Hi Mariusz,

you could psqlODBC to conect the postgre database and some VBA coding to
export the data.I have done the similar kind of work for mysql using MYODBC

Thanks
Xcelion



"Mariusz" wrote:

Hello,

I'd like to export data from MS Excel sheet to external PostreSQL
database. If anyone has experience in solving such a problem - please
tell me :)

Thanks in advance for reply,
Mariusz

export data from MS Excel sheet to external database
 

Thanks Xcelion,

If you could send me your VBA code I'd be grateful

mariusz

Xcelion wrote:
Hi Mariusz,

you could psqlODBC to conect the postgre database and some VBA coding to
export the data.I have done the similar kind of work for mysql using MYODBC

Thanks
Xcelion