Accessing a dll from within Access

[bg_ie]

Hi,

My company has a database which I need to read from my database now
and again. This db can only be read via a dll written in C#. I need to
read data from this database and popule a table in my own database
which is programmed via MsAccess.

How would I go about communicating to the dll via VBA,

Thanks,

Barry.

[Tom van Stiphout]

On Mon, 10 Dec 2007 02:27:56 -0800 (PST), bg***@yahoo.com wrote:

That depends because there are 3 styles of DLLs.
If it's a .Net DLL you can't call it.
If it's a .Net component with a COM wrapper around it, it's like any
other COM DLL and you can set a reference (Code window Tools >
References) and create objects of the exposed types call their public
interfaces.
If it's a classic DLL you can write a Declaration line in a standard
module and call the API.

-Tom.

>Hi,

My company has a database which I need to read from my database now
and again. This db can only be read via a dll written in C#. I need to
read data from this database and popule a table in my own database
which is programmed via MsAccess.

How would I go about communicating to the dll via VBA,

Thanks,

Barry.