access中可不可同时运行多条查询语句?
我现在有许多类似的查询语句,我想同时查询这几条语句:如下:
SELECT * into ZhongXin_DXG_Line FROM ZhongXin_Line where Left(起点,3)='DXG'
SELECT * into ZhongXin_GBG_Line FROM ZhongXin_Line where Left(起点,3)='GBG'
SELECT * into ZhongXin_GDG_Line FROM ZhongXin_Line where Left(起点,3)='GDG'
出错,有哪位大哥知道在access中同时进行我条语句的查询,小弟万分感谢!!!