PDA

View Full Version : MS excel connection to SQL



svoco
10-20-2011, 04:49 AM
Hello,

I'm trying to connect to HM SQL database from MS excel
Tried this one in excel2007
Data>from other sources>SQL database> then new tab opens and requires server name and log on credentials

i'm not sure about servername? is this the name of server? PostgreSQL 8.4
or where can i find it

cant import picture so here it is:
http://www.rsts.sk/images/excelsqlerror.jpg

i'm sure with username and password its postgres and xxxx

can u help me please

Patvs
10-20-2011, 10:56 PM
Run dbcontrolpanel.exe in the HoldemManager folder.

Default username is: postgres
Password: postgrespass
Port: 5432
Server: 127.0.0.1

svoco
10-21-2011, 05:12 AM
I'm not sure what you meant or what it should do but I know everything u provided to me
I can work with sql, i can do inside that database using pgAdminIII
login to database, see every tables, functions everything
execute selects and get reports from it

the only problem is that I can't connect from MS excel directly to pSQL database...
I just dont want to export to excel, I want to connect and then work with it directly from MSexcel

I know its just some stupid 1 step I'm missing here and can't find it

can u help me with that

netsrak
10-22-2011, 05:35 AM
The server name is not postgresql, it is localhost or 127.0.0.1 or something like that

svoco
10-22-2011, 01:47 PM
any idea how can I get servername? can I get it from the picture I provided (server properties)?
I tried:
holdemmanager
postgres
127.0.0.1
postgreSQL 8.4
postgresql-8.4

all of them acces denied or server does not exist, but i should have access as I can get inside that postgreSQL database using PGadmin and read, write, delete...

any SQL expert here?