Pulling parameter data from access and export to excel

[frankcpl]

I have run into an issue that has me really confused. I would like help if anyone is able to help. I have a sharepoint site with an access database one it. I am able to create a query that ask for parameters and it works great. The problem I am having is when I am trying to print the query. The data is too long for the report on landscape. What I am trying to do is find out if there is a way to create a button that will ask for two parameters and then export the data to an excel spreadsheet. Is this possible? If So, can anyone help me figure it out.

 

[SkipVought]

Why not Run a query IN Excel, rather than in Access?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[frankcpl]

Is that possible with the database being on a sharepoint site?

 

[SkipVought]

Probably not.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[frankcpl]

Thanks for the thought, I will look into it though. Might be a way for Excel to access the sharepoint and pull in data. At least it is worth looking into.

 

[SkipVought]

It might work IN SharePoint. I've never messed with SP.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]