从SQL Server查询到MS Access创建新表。 [英] Making a new table from a SQL Server Query to MS Access.
问题描述
我正在研究一个在SQL Server上有数百万条记录的表，不幸的是，该表每天都被删除并重新生成，所以它们不会将这个表编入索引。
查询此表需要一段时间，因为它不是索引。它包含来自所有部门的预约信息，当然我们只关心我们的部门。
因此，当我们从Access DB（使用Passthrough）运行查询时，它仍然需要几分钟左右的时间拉出我们23,000多个约会。
在Passthrough查询上运行Make Table查询很简单，但仍需要时间。
有没有无论如何，我们可以要求SQL Server在我们的Backend Access DB上创建一个新表格吗？
我觉得它几乎可以立即制作该表...
类似
Hi,
I am working on a table that has millions of records located on SQL Server unfortunately the table is dropped and remade everyday so they don''t index this table.
It takes a while to query this table because it is not index. It contains appointment information from all departments of course we only care about our department.
So when we run a query from our Access DB (Using Passthrough) it still takes couple of minutes or so to pull our 23,000 odd Appointments.
Running a Make Table query on that Passthrough query is easy, but still takes time.
Is there anyway we can ask SQL Server to make a new table on our Backend Access DB??
I have a feeling it will be able to make that table almost instantly...
Something like
推荐答案
是否使用SQL Server创建表或访问，它不会是即时的。它需要传输数百万行，这需要时间。
Whether you make the table using SQL Server or Access, it will not be instant. It will need to transfer those millions of rows and that will take time.
@Rabbit
我意识到它不会是即时的，但我认为服务器创建表的速度比Access查询服务器并在慢速计算机上执行要快得多，而且服务器表有数百万不可能数百万，但我们的部门可能必须少得多你必须了解我们公司只有100个中的一个部门。
所以mm你知道怎么做吗？很抱歉迟到的回复我周末不工作。
@Rabbit
I realize that it won''t be instant, but I think the server would create the table much faster than Access querying the server and doing it on my slow computer, and it won''t be millions the server table has millions, but our department is probably must way less you gotta understand we are only one department out of 100s in our company.
So mm do you know how to do it? Sorry for the late reply I don''t work on weekends.
在Access中用哪一个创建表格并不重要，速度会相似。瓶颈不是哪个程序创建表，而是网络速度。
除非你说Access数据库与SQL Server在同一个文件服务器上，那会更快。但是，如果Access数据库与SQL Server位于不同的服务器上，那么您选择创建表的程序不会对所需的时间产生很大的影响。
It won''t matter which one you use to create the table in Access, the speed will be similar. The bottleneck is not which program creates the table, it''s the network speed.
Unless you are saying that the Access database is on the same file server as the SQL Server, then that will be faster. But if the Access database is on a different server than the SQL Server, which program you choose to create the tables won''t make a big difference in how long it takes.
这篇关于从SQL Server查询到MS Access创建新表。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
