importing access data into excel

  • Thread starter Thread starter lmdolph
  • Start date Start date
L

lmdolph

Hi
I´m from Portugal and.
I would like you to help me to make a project that import records of
specific acess database into a excel sheet.
For example:
A database "Test.mdb" winth a table with fields "code", "Name", an
"Obs".
A excel sheet "Test.xls". And when i enter in excel sheet a code tha
exists in "test.mdb" automatically run a macro or other function tha
inserts the repective "Name" and "Obs" in excel sheet in the nex
columns.

I Know that i have to search for VBA projects but i cant find them.
I would be greatful if you could help me making this project.

Greatfully
(e-mail address removed)
 
Bon Dia,
The way I would do it is from Access: Tools, Office links, Analyse it with
Excel.

HTH

Gilles Desjardins
 
Back
Top