ACCESS---->EXCEL
SELECT * into tmp in 'c:/tmp/bbb.xls' 'excel 8.0;' from Table1;
EXCEL---->ACCESS
insert into Table1
select * from [sheet1$] in 'c:/tmp/aaa.xls' 'excel 8.0;'
DBF---->ACCESS
insert into Table1
select * from P9 in 'C:/tmp/' 'dbase 5.0;'
(源文件是:C:/tmp/P9.DBF)
CSV--->ACCESS
insert into tel
SELECT *
FROM [Text;database=C:/tmp].p5.csv
(源文件是:C:/tmp/P5.csv)