Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 39
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Excel PivotTable for a huge DataBase from External Data marcher Excel Discussion (Misc queries) 0 September 9th 08 07:59 PM
How do I use Excel to post data to an external database? ctimrun Excel Discussion (Misc queries) 0 June 14th 05 05:39 AM
How can I export data from an Excel form into an external Excel d. vonda Excel Discussion (Misc queries) 1 April 21st 05 01:20 PM
From Excel 97 Programmatically create access 97 or 2000 database and export data to. [email protected] Excel Programming 0 December 23rd 04 10:44 PM
Populating data from an external database DavidC[_2_] Excel Programming 1 August 18th 04 06:05 AM


All times are GMT +1. The time now is 06:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"