Connect to MS Access with Password via VBA
 

My users have a MS Access database with password. I was asked to write a
macro in Excel to connect to MS Access, extract the data based on a certain
criteria. Put in Excel workbook and email to a recipient automatically. Is it
doable?

Can you help me with the code.

Thanks
Matelot

Connect to MS Access with Password via VBA
 

Hi Matelot,

For the data extraction, see Ole P. Erlandsen at:

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

For the email requirements, see Ron de Bruin at:

http://www.rondebruin.nl/sendmail.htm



---
Regards,
Norman



"matelot" wrote in message
...
My users have a MS Access database with password. I was asked to write a
macro in Excel to connect to MS Access, extract the data based on a
certain
criteria. Put in Excel workbook and email to a recipient automatically. Is
it
doable?

Can you help me with the code.

Thanks
Matelot

Connect to MS Access with Password via VBA
 

Thanks. This will help me get started.

"Norman Jones" wrote:

Hi Matelot,

For the data extraction, see Ole P. Erlandsen at:

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

For the email requirements, see Ron de Bruin at:

http://www.rondebruin.nl/sendmail.htm



---
Regards,
Norman



"matelot" wrote in message
...
My users have a MS Access database with password. I was asked to write a
macro in Excel to connect to MS Access, extract the data based on a
certain
criteria. Put in Excel workbook and email to a recipient automatically. Is
it
doable?

Can you help me with the code.

Thanks
Matelot