Write value to an Excel VBA variable by reading Access DB?

[Alan Ibbotson]

I would like to assign a value to variable in Excel VBA by looking up the
data in a Access database table. Could someone provide a programming example
please. I have fiddled around with setting up references and trying to use
SQL but this is all new to me and I am not sure if I am heading in the right
direction.

Back ground information if you are interested:
I log all project details in a database, project number(primary key),
customer, many project details, many customer details. I use Excel to
generate a Bill of Materials for each project. I want to include all the
customer details (name, location, etc.) on the Excel B.O.M in the header
part. I can right code to get the right format for the header I just need to
know how to return information from the database.

Your help in this matter would be greatly appreciated.

 

[Dave Patrick]

This should get you started.

http://msdn.microsoft.com/library/en-us/odeopg/html/deovrusingadotoworkwithaccessdatabases.asp

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
|I would like to assign a value to variable in Excel VBA by looking up the
| data in a Access database table. Could someone provide a programming
example
| please. I have fiddled around with setting up references and trying to use
| SQL but this is all new to me and I am not sure if I am heading in the
right
| direction.
|
| Back ground information if you are interested:
| I log all project details in a database, project number(primary key),
| customer, many project details, many customer details. I use Excel to
| generate a Bill of Materials for each project. I want to include all the
| customer details (name, location, etc.) on the Excel B.O.M in the header
| part. I can right code to get the right format for the header I just need
to
| know how to return information from the database.
|
| Your help in this matter would be greatly appreciated.
|
|