利用IN 子句,例:dBASE III 或 IV:dBASE III 表,以 "dBASE III;" 替代 "dBASE IV;"。SELECT CustomerID INTO yourAccessTable FROM Customer IN "C:\DBASE\DATA\SALES" "dBASE IV;" WHERE CustomerID Like "A*";SELECT CustomerID INTO yourAccessTable FROM Customer IN "" [dBASE IV; Database=C:\DBASE\DATA\SALES;] WHERE CustomerID Like "A*";
IN "C:\DBASE\DATA\SALES" "dBASE IV;"
WHERE CustomerID Like "A*";SELECT CustomerID INTO yourAccessTable
FROM Customer
IN "" [dBASE IV; Database=C:\DBASE\DATA\SALES;]
WHERE CustomerID Like "A*";