ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Connecting to an Access database (https://www.excelbanter.com/excel-programming/410516-connecting-access-database.html)

NateBuckley

Connecting to an Access database
 
Hello, I'm looking for a good tutorial on connecting to an Access database
and can't find any. Due to not everyone at work having Access on their
machines, I'm having to have the front end of the system running through
Excel (as they all have that) and connect to a database, I'm just wondering
if anyone could spare a few minutes writing the code to connect to a database
along with how to close the connection.

I can figure out all the SQL type commands to get information from it, i'm
just having problems finding a good tutorial on showing me how to actually
get connected.

Thanks for any help in advance.

Norman Jones[_2_]

Connecting to an Access database
 
Hi Nate,

See Ole P Erlansen at:

http://www.erlandsendata.no/english/...php?t=envbadac



---
Regards.
Norman


"NateBuckley" wrote in message
...
Hello, I'm looking for a good tutorial on connecting to an Access database
and can't find any. Due to not everyone at work having Access on their
machines, I'm having to have the front end of the system running through
Excel (as they all have that) and connect to a database, I'm just
wondering
if anyone could spare a few minutes writing the code to connect to a
database
along with how to close the connection.

I can figure out all the SQL type commands to get information from it, i'm
just having problems finding a good tutorial on showing me how to actually
get connected.

Thanks for any help in advance.



NateBuckley

Connecting to an Access database
 
You Beauty.

Thanks muchly.



"Norman Jones" wrote:

Hi Nate,

See Ole P Erlansen at:

http://www.erlandsendata.no/english/...php?t=envbadac



---
Regards.
Norman


"NateBuckley" wrote in message
...
Hello, I'm looking for a good tutorial on connecting to an Access database
and can't find any. Due to not everyone at work having Access on their
machines, I'm having to have the front end of the system running through
Excel (as they all have that) and connect to a database, I'm just
wondering
if anyone could spare a few minutes writing the code to connect to a
database
along with how to close the connection.

I can figure out all the SQL type commands to get information from it, i'm
just having problems finding a good tutorial on showing me how to actually
get connected.

Thanks for any help in advance.



Bob Phillips

Connecting to an Access database
 
See
http://www.carlprothman.net/Default....orMicrosoftJet

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"NateBuckley" wrote in message
...
Hello, I'm looking for a good tutorial on connecting to an Access database
and can't find any. Due to not everyone at work having Access on their
machines, I'm having to have the front end of the system running through
Excel (as they all have that) and connect to a database, I'm just
wondering
if anyone could spare a few minutes writing the code to connect to a
database
along with how to close the connection.

I can figure out all the SQL type commands to get information from it, i'm
just having problems finding a good tutorial on showing me how to actually
get connected.

Thanks for any help in advance.





All times are GMT +1. The time now is 03:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com