View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
FerGo FerGo is offline
external usenet poster
 
Posts: 1
Default Any sample to connect a remoted database through Excel?

You can try through an ODBC connection, depending of what DB you try to
connect. After that you only need to configure the connection in the DATA -
CONNECTIONS tab in Office Excel 2007.

Regards.

"Eric" escribió en el mensaje de
...
Does anyone have any sample to connect a remoted database through Excel?
I need to make a connection with a database in China, and I locate in HK.
Could anyone give me any suggestions on what I need to retrieve any data
from
a database?
What I can think of is
URL, username, password, ...
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric