简单的问题都有分啊！！！！大家都进啊，哈哈哈

[sirious]

怎么样把EXCEL中数据导入ACCESS？最好有关键代码？谢谢

[sirious]

不行啊
提示找不到可安装的ISAM！
帮帮忙啊？

[tztz520]

http://community.csdn.net/Expert/FAQ/FAQ_Index.asp?id=159716

[wslz2001]

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;
--------------------------------------------------------------------------------