Assuming you have the ODBC drivers and a stable connection to the database
server then you should be able to use MS Query which you access via Data -
Import External Data - new Database Query.

That will allow you to read from the database. If you need to write back
then you will need to use VBA code with ADODB Recordsets.
--
HTH...

Jim Thomlinson


"Eric" wrote:

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