I need to link a cell in Excel to a field in Access

[Lorelai]

I posted this in the Access forum too.

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.

 

[Asator]

Have you tried just doing a normal database query from excel, and setting it to refresh automatically every x seconds?

 

[Lorelai]

I can run a query on an access database from excel?

 

[Asator]

Yep... look in the data menu. In 2003 its "Import external data", in 2010 its Import data from Access.

You can either use MS Query or VBA to construct complex queries.

 

[Lorelai]

And I can add data to the spreadsheet that is not in the database? I'll give this a try. Thanks!