Excel Connection

[Vinnie via AccessMonster.com]

Hi,

I've only recently discovered linking Excel to Access, so my problem is
fairly basic:

I want to import data to Excel from a query in Access. The Access query
requires you to select a customer first.

Do I have to run the query in Access first, or is it possible to select the
customer via Excel?

Thanks!

 

[Guest]

You are mixing apples and oranges. Linking to a spreadsheet is different
from importing or exporting to Excel. You can't update a Linked Excel
spreadsheet. There are two ways to get data from Access into Excel. One is
using COM and the other is exporting, whether it be manually or using the
TransferSpreadsheet method.

If an Access query requires a parameter (Customer), you will have to select
the customer in Access. If you want to select the customer from Excel, you
could MSQuery and do it all within Excel.

 

[Guest]

Hi Vinnie - depending on what version of Excel you are using you actually can
import data into Excel. Try Data/Import External Data/ New Database Query.
Find you Access MDB and choose the Table or Query you want. THe next steps
are for filtering and sorting. This is where you choose the customer. Each
time you open the Excel SS it updates the data automatically. It does not
however work like an Access Query (even if it is based on one) and ASK you
for a different customer. To do this put the cursor in a cell withing the
data and go back to Data/Import External Data / Edit Query.

We use this method a lot for users who are Excell competent or who do not
have Access on there computer.
Hope this helps. --- yours Dika