动态链接电子表格？ [英] Dynamic Linked Spreadsheet?
问题描述
您好，
我想知道是否可以在Access中根据其所在的Access数据库的文件名创建链接电子表格的路径。例如，如果数据库是db_2008-01-28，我希望链接的电子表格路径为c：\ path \2008-01-28_data.xls。通过这种方式，我可以创建数十个不同名称的小型（<1MB）数据库，这些数据库将基于各自的日期数据。
或者，如果有人可以帮助我想一个更好的解决方案也会很棒。基本上我有一个数据库，以excel文件的形式链接到每日数据。 excel文件太多太大，无法将它们全部放在数据库中。数据库基本上只是一个数据存储器，它接收它链接到的每日数据，加入/过滤/等等，然后吐出一个查询，我已开发的excel应用程序中的数据透视表使用。
更复杂的是，没有人对数据库所在的目录有写访问权。这就是为什么我需要数据库自己更新其链接表路径从excel应用程序调用主查询。
感谢您的帮助！
Hello,
I was wondering if it were possible in Access to make a linked spreadsheet''s path be based upon the filename of the Access database that it is in.
For instance, if the database is db_2008-01-28, I''d want the linked spreadsheet path to be c:\path\2008-01-28_data.xls. This way, I could create dozens of small (<1MB) databases with different names that would be based on their respectives day''s data.
Alternatively, if someone could help me think of a better solution that would be great too. Essentially I have a database that linkes to daily data in the form of excel files. The excel files are too many and too large each to have them all in the database. The database is essentially just a data crucher that takes the daily data that it''s linked to, does joins/filters/etc., then spits out one query that a pivot table in an excel application I''ve developed makes use of.
Further complicating things is that no one has write access to the directory that the database is in. That''s why I need the database to update its linked table paths by itself whenever the main query is called from the excel application.
Thank you for any help!
推荐答案
哎呀，忘了提这是Windows XP上的Access 2007。
Whoops, forgot to mention this is Access 2007 on Windows XP.
变量currentdb.Name将返回数据库名称和完整路径。
所以使用：
The variable currentdb.Name will return the database name and the full path.
So using:
如果你想动态翻译
If you wish to dynamically translate
这篇关于动态链接电子表格？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
