SELECT * FROM [;database=C:\db2.mdb;pwd=1].某表 AS 别名表 WHERE ……-------------------------------------------------------------------------------- 关于文本文件可以这样: select * from [Text;FMT=Delimited;HDR=Yes;DATABASE=C:\;].[aparm#txt]; 关于Excel可以这样: insert into 表 SELECT * FROM [Excel 5.0;HDR=YES;DATABASE=c:\test.xls].[sheet1]; -------------------------------------------------------------------------------- Example 1 The following SQL code shows you how to export a table to a text file: SELECT * INTO [Text;FMT=Delimited;HDR=Yes;DATABASE=C:\TEMP;].[OutCustomers#txt] FROM Customers;
Example 2 The following SQL code shows you how to import a table from a text file (this is the one created in the first example): SELECT * INTO ImpCustomers FROM [Text;FMT=Delimited;HDR=Yes;DATABASE=C:\TEMP;].[OutCustomers#txt];
Example 3 To modify the SQL statement so that it exports the data in Unicode text format, add the following option to the connection argument: CharacterSet=Unicode
For example, you can modify the statement in Example 1 to the following: SELECT * INTO [Text;FMT=Delimited;HDR=Yes;DATABASE=C:\TEMP;CharacterSet=Unicode].[OutCustomersUNI#txt] FROM Customers; --------------------------------------------------------------------------------
提示找不到可安装的ISAM!
帮帮忙啊?
关于文本文件可以这样:
select * from [Text;FMT=Delimited;HDR=Yes;DATABASE=C:\;].[aparm#txt]; 关于Excel可以这样:
insert into 表 SELECT * FROM [Excel 5.0;HDR=YES;DATABASE=c:\test.xls].[sheet1];
--------------------------------------------------------------------------------
Example 1
The following SQL code shows you how to export a table to a text file:
SELECT * INTO
[Text;FMT=Delimited;HDR=Yes;DATABASE=C:\TEMP;].[OutCustomers#txt]
FROM Customers;
Example 2
The following SQL code shows you how to import a table from a text file (this is the one created in the first example): SELECT * INTO ImpCustomers
FROM [Text;FMT=Delimited;HDR=Yes;DATABASE=C:\TEMP;].[OutCustomers#txt];
Example 3
To modify the SQL statement so that it exports the data in Unicode text format, add the following option to the connection argument: CharacterSet=Unicode
For example, you can modify the statement in Example 1 to the following:
SELECT * INTO
[Text;FMT=Delimited;HDR=Yes;DATABASE=C:\TEMP;CharacterSet=Unicode].[OutCustomersUNI#txt]
FROM Customers;
--------------------------------------------------------------------------------