ms访问所有数据库的变量查询 [英] ms access variable query for all the database
问题描述
HI
我有一个问题需要解决,所以我最终在我的访问数据库中有500个小桌子。
ex
表A
栏100 150 200 300
排50 60 70
和单元格交叉口是价格
table b
栏135 145 205 310
row 54 62 75
和牢房交叉口是价格
因此我需要在访问中进行查询,我发送参数(表名,列,行)并获取价格而不是获取所有表格到prog将是超级慢的
然后从我的编程我应该调用查询给它表名,列,行和查询返回交集单元格!!
我的第一个问题链接
http://www.codeproject.com/Questions/786803/ms-access-Matrix-database-for-vb-bet
HI
I had a problem that coudnt be solved so i ended up having 500 small tables in my access database.
ex
Table A
column 100 150 200 300
row 50 60 70
and the cell intersection is the price
table b
column 135 145 205 310
row 54 62 75
and the cell intersection is the price
so i need to make a query in access that i send the parameters (table name , column, row,) and get the price instead of getting all the tables to the prog which will be super slow
then from my prog I should call the query giving it table name , column , row and the query return the intersection cell!!
my first problem link
http://www.codeproject.com/Questions/786803/ms-access-Matrix-database-for-vb-bet
推荐答案
这篇关于ms访问所有数据库的变量查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!