Excel 2k7 & DGET() in actual database

[JET_Fusion]

Hi

I'm well versed in Excel, but I've never used the DGET() function before.

Problem: have data in an Access database query that changes daily and I need to put this data into an Excel spreadsheet; I don't want to do it manually. I can't use a macro. LookUp's seem cumbersome.

The DGET() function, by its definition, seems to be just the thing. I can get this thing to work in another worksheet, but I can't figure out how to get it to look within an actual database.

What's the syntax for directing the DGET() function to look at an actual database file? Is there a better way to do this?

Thanx...JET_Fusion

 

[Fazza]

Hi,

One approach might be a query table? This could be done without code and set to refresh on file open so that it would be updated every day. Suggest you google for "examples of Excel external data queries". By using appropriate SQL you should be able to get any result you need. Please post again if you want assistance with any SQL.

Regards, Fazza

 

[JET_Fusion]

Thank you for the info. I'll give it a try.