Import Data

[Doug Loewen]

I have an Access data base with "Customer Table" (name,
address, phone, etc.), "Supplier Table" (name, address,
phone, etc.) and "Model Table" ( size, color, specs, etc.)

I want to import this info into an Excel "Etimating"
spread sheet. I would like to pull the info for one
customer, many suppliers and one model from the data base,
for each estimate that I create. I would like the
imported info scattered to various cells in various
locations in the estimate sheet.

Is this possible with some basic code? I'm using Office
XP in Windows XP.
Thanks
Doug

 

[merjet]

Check out the examples at:
http://www.erlandsendata.no/english/vba/adodao/index.htm

HTH,
Merjet

 

[Steve Smallman]

Doug,

this is possible, but to provide a real answer more detail is needed.

But, before heading down that path, is there a specific reason you need to
import the data into excel and then manipulate it? wouldn't it be easier to
produce an Access report and export the report to Excel? sorry, just
asking.....

Steve