Access and link Excel?

G

Guest

I have Office 2000.

I have writen a db to store customers, names address's.

Is there a way to link up Excel and Access so that I can click on an Excel
template in Access and Excel will open with fields populated from Access.

Can you point me to some places that might have the code etc to do something
like this. The main difficulty I think is automatically transfering the
fields from access into Excel.. Act contact manager actually does this but
it simply will not work on my machine. (Windows 2000 Server) I have
installed it 4 times.

Does anyone have any info that would be helpfull to get started on this
project ?

Regards
 
G

Guest

Joseph Meehan said:
Go to the "Tools" menu selection and then "Office Links" then "Analyze
with Excel" Is that what you want?


Set up a query and use the query as the source.
Click to expand...
Not exactly.

What I want is to be able to open a form in excel and that form to be
populated with the info from Access.

In other words
I do quotes. I want the quote to have th current records Name address phone
etc. All put into apropriate fields of my form that I created in excel.
Then when I have another client I want to send a quote to, I go to the
record in Access, click some button and the form opens again in excel and
again is populated with this cusomers data.

Does that make sense?
 
G

Guest

Well I have discovered that you can link Excel and Access together and it is
relatively easy.

See http://forums.aspfree.com/t19766/s.html

Look for the Phrase "My suggestion is to create a new database ..." This
explains it.
You can do it autmatically through a macro and that is described in the same
link which starts with "Well you got me confused as to what you want....

I have played with Access and Excel for years and have never seen this
before in my life. It is really quite amazing. The part I have not figured
out yet is how take a contact and export it into a the linked table that
automatically updates Excel.

Regards
 
Top