Access and link Excel?

[Joseph Meehan]

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.

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

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..

Set up a query and use the query as the source.

 

[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

 

[Guest]

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.

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?

 

[Joseph Meehan]

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?

Yea, that makes sense. Of course to me I would just use Access and
maybe Word for the final print if I needed something fancy that I could not
easily due in Access. I don't really know Excel well, so I would guess you
need advice from an Excel person. That would be in one of the Excel
newsgroups. I fear you may run into something of the same issue there as
not many of them are going to know Access well.

Maybe someone here knows Excel well enough to help you out. I believe
you can do it, I just am not the best person to help you out.

 

[Joseph Meehan]

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

I know you can, and I know Excel has forms, I just never had any need to
use them. I was the database person where I worked and left the spreadsheet
stuff for others.

 

[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