从用户级安全访问Db导入数据 [英] Importing Data From User-Level Secure Access Db
问题描述
我有一个数据库，我已经建立了很长一段时间。我想将数据库的一些方面转移到Excel中，以便我可以执行更高级的数据透视表和其他报告。我的问题是我无法获得查询以实际提取数据。
首先，我在Access数据库上设置了特定的用户级安全设置。我认为这是导致挂断的主要原因（因为我可以有效地为尚未设置的数据库创建Excel查询）。
这是发生的事情：
我进入Excel，运行New Database Query ..
我点击MS Access数据库
我浏览我要连接的数据库并选择它
此时查询向导出现并说选择列
然后它列出我的所有表格旁边都有加号标志，以便我可以展开它们
但是，当我尝试扩展表名，以便我可以拉字段，没有任何反应。加号变为负值，没有任何扩展。
当我尝试取消向导并只通过Microsoft Query添加表时，它说它无法访问[表]。任何建议??
I have a database that I''ve been building for quite some time. There are a few aspects of the database that I would like to pull over into Excel so that I can do some more advanced pivottable and other reports. My problem is that I can''t get the Query to actually pull data.
First of all, I have set up specific user-level security settings on my Access database. I think this is the main thing that is causing the hangup (since I can effectively create Excel queries for databases that have not been set up for this).
This is what happens:
I go into Excel, I run "New Database Query.."
I click MS Access Database
I browse for the database I want to connect to and select it
At which point the Query Wizard comes up and says "Choose Columns"
It then lists all of my Tables with ''plus'' signs next to them so that I can expand them
However, when I try to expand the table names so that I can pull fields, nothing happens. The plus turns to a minus and nothing expands.
When I try to cancel the wizard and just add tables via Microsoft Query it says that it "Can''t access [the] table". Any suggestions??
推荐答案
如何从Access中导出w /而不是从Excel中导入？
使用这个或类似的东西：
What about exporting from w/in Access instead of importing from w/in Excel?
Using this or something similar:
我可以拿一张表并将其导出到Excel（即使只是右键单击 - >出口）。转移就好了。问题是我想根据这些信息在Excel中创建一个报告，该信息不断更新数据库中的当前信息，而最终用户不必在每次想要执行某些操作时导出数据。
因此，我想创建一个从Excel到Access的链接，每次打开Excel文件时都可以更新。我可以很好地链接其他数据库，但是我无法链接到这个Access文件。
最初我将Access数据库设置为不同的安全文件（不同的< filename> .mdw）这样我就可以拥有不同的用户级安全密码和权限。我认为这可能导致了这个问题。但是，我已经将活动安全文件返回到所有Access文件的默认安全文件（因此它与使用该链接的那些Access文件相同），但仍然无法将Excel链接到我的数据库。 />
我还尝试从头开始创建一个新数据库并导入我的所有表，报告，查询和VBA。但我无法从Excel链接到新数据库（结果相同）。
对工作模型的任何其他建议？如果可能的话，我真的需要明天找到一个修复，因为我周三有一个演示文稿，并且非常希望能够将这部分作为一个额外的惊喜/奖励。
谢谢非常感谢你的时间和知识。
~Luke
I can take a table and export it to Excel (even with just the right click --> export). That transfers over just fine. The problem is that I want to create a report in Excel based off of this information that constantly updates with current information in the database without the end user having to export the data each time they want to do something.
As such, I would like to create a link from Excel to Access that can be updated each time the Excel file is opened. I can link with other database just fine, but I can''t link with this Access file.
Originally I had set my Access database to a different Security file (a different <filename>.mdw) so that I could have distinct user-level security passwords and permissions. I think that this may have caused the problem. However, I have since returned the active security file to the default security file for all Access files (so that it is the same as those Access files that work with the link) and still I am unable to link Excel with my database.
I have also tried to start a new database from scratch and import all of my tables, reports, queries, and VBA. But I am unable to link from Excel to the new database either (same result).
Any other suggestions for a working model? If possible, I really need to find a fix by tomorrow as I have a presentation on Wednesday and would really like to be able to present this portion as an added surprise/bonus.
Thank you very much for your time and knowledge.
~Luke
我不是Excel / Access互动专家，但我'我已经召集了几位在这方面广泛开展工作的专家。
在此期间，您是否尝试将表格导出到Excel，然后从Access中导出电子表格链接功能？笨蛋，我知道，但这是我现在所能想到的，对不起！
问候，
Scott
I''m not an expert on Excel/Access interaction, but I''ve put out a call for a couple of our experts who work extensively in this area.
In the meantime, have you tried exporting the table to Excel, then from within Access using the spreadsheet link feature? Clunky, I know, but it''s all I can think of at the moment, sorry!
Regards,
Scott
这篇关于从用户级安全访问Db导入数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
