更新时间:2023-02-03 16:24:03
您可以在从CSV文件创建新表的Access连接中再次运行查询或追加现有表格。
You can run a query agains an Access connection that creates a new table from a CSV file or appends to an exisiting table.
创建表格的SQL类似于:
The SQL to create a table would be similar to:
SELECT * INTO NewAccess
FROM [Text;FMT=Delimited;HDR=NO;DATABASE=Z:\Docs].[Table1.csv]
附加到表格:
INSERT INTO NewAccess
SELECT * FROM [Text;FMT=Delimited;HDR=NO;DATABASE=Z:\Docs].[Table1.csv]