Need to link a cell in Excel to a field in an Access query

[Lorelai]

I have an access database. I have an Excel spreadsheet with a ton of info I don't want in my database. There are certain cells that I have to fill in with info from Access every time I present this spreadsheet (weekly). I would love to be able to link these individual cells to queries in my database so that every time I open the spreadsheet, it automatically updates with the new numbers from my database.

I tried creating a query that literally only has the one field I want, then copying it and doing a "paste special link" in Excel. It pasted the info (with the column header which I'd rather not see but could live with) but when the info in the query changed, the spreadsheet did not.

I'm using Excel 2007 and Access 2003.

Is this even possible?

Thank you so much for your time.

 

[vavs]

I do this all the time. In Excel 2007 there is a Data tab. If you select that you can get external data from Access. I have some people who are on Excel 2003 and can only use Access 2003. I have both 2003 and 2007 in both Access and Excel and switch between the two often. When you get into the "From Access" you can then select the database and then select the table or query that you want to display. You can paste it into a worksheet and go from there. What I have done is do a query in Access and then just put the results out in Excel. It will requery when I open the Excel spreadsheet when I open(provided you have the correct settings in Excel) To that end make sure you refresh all on open using a macro in Excel.

HTH

 

[Lorelai]

I tried that, but it's only showing me tables to select from, not queries. Any idea why that might be?

 

[vavs]

I just looked at mine and it is showing the queries. I put a qry at the beginning of a query to help me identify it. Also, if you expand the table it has a column and the designation shows a view rather than a table.

If you are not getting that, I would look at your ODBC connection and see if that is restricted in some way.