且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

将CSV文件复制到MS Access Table

更新时间: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]