Importing worksheets to a database

[BlakeDrol]

Hey everyone,

I am new to this forum. I have been programming excel macros for a shot time now and am trying to make a process where i can update a database through excel. I want to take my current worksheet update my access database without having to open up accesss. then pull qrys back from the database to excel. is this possible? or is there an easier way i can run SQL queries in excel?

Thanks
Blake

[MaC]

Try do do it over ADO library. Google should be helpful. The syntax of ADO
support in VBA is similar in Excel and Access, so you'll find there enough
info to start.

Good luck
MaC


Użytkownik "BlakeDrol"
<[email protected]> napisał w wiadomości
news:[email protected]...
>
> Hey everyone,
>
> I am new to this forum. I have been programming excel macros for a
> shot time now and am trying to make a process where i can update a
> database through excel. I want to take my current worksheet update my
> access database without having to open up accesss. then pull qrys back
> from the database to excel. is this possible? or is there an easier way
> i can run SQL queries in excel?
>
> Thanks
> Blake
>
>
> --
> BlakeDrol
> ------------------------------------------------------------------------
> BlakeDrol's Profile:
http://www.excelforum.com/member.php...o&userid=28880
> View this thread: http://www.excelforum.com/showthread...hreadid=486976
>
>