一、将ACCESS表导出为CSV文件:
Select * INTO [TEXT;FMT=CSV;DELIMITED;HDR=YES;DATABASE=E:\temp\].test.csv FROM Sheet2;
二、导入CSV文件并生成新的ACCESS表:
Select * INTO test FROM [TEXT;FMT=CSV;DELIMITED;HDR=YES;DATABASE=e:\Temp\].[test.csv];
三、将CSV文件追加到现有的ACCESS表中:
Insert INTO test Select * FROM [TEXT;FMT=CSV;DELIMITED;HDR=YES;DATABASE=e:\Temp\].[test.csv];