Query Help
hi
on the menu bar....
dataimport external datanew database query
follow the wizard.
set sorce = MS access db
brouse and select your access db
the query wizard has four screens.
1.scroll down and select your query
select all of your fields.
2.filter if needed
3. sort if needed
4. return to excel or edit in ms query.
note: if you have prompts for parameters(cirteria) in the query, you will
have to move them to the excel side or you will be error messages ie too few
parameters - expected 1(or whatever)
you can have criteria such as date yesterday with no errors but if the
query prompts for criteria(asks for input), these must be moved to the excel
side. do this on screen 4 edit in ms query.
post back if you have problems.
Regards
FSt1
"Suzanne" wrote:
I have a MS Access (Access 2003) query that I need to be linked to excel
(Excel 2003) and vise versa, not everyone in my company has MS Access so they
need to be able to enter information into this excel document that will then
update my access query, i think this possible, but i just don't know how to
do it. Can anyone help?
|