J
JiiPee
Hi
I've been trying to figure out a way to import Access query to Excel. There
seems to be at least 2 data links that should function ok.
1. From Access
2. From Microsoft Query
The option nr 1 does not allow dynamic filtering of data by using parametres
as part of SQL statement. The second one works fine with more simple links to
tables or light access queries. But when I have a query linking several
tables the optin nr stops completely whereas the option nr 1 is pretty fast,
but does not allow filtering.
Would you have any suggestions on how to go forward?
I've been trying to figure out a way to import Access query to Excel. There
seems to be at least 2 data links that should function ok.
1. From Access
2. From Microsoft Query
The option nr 1 does not allow dynamic filtering of data by using parametres
as part of SQL statement. The second one works fine with more simple links to
tables or light access queries. But when I have a query linking several
tables the optin nr stops completely whereas the option nr 1 is pretty fast,
but does not allow filtering.
Would you have any suggestions on how to go forward?