MS Access - 如何从MS Excel导入数据 [英] MS Access - How to import data from MS Excel

问题描述

您知道如何将数据从MS Excel导入MS Access吗？我尝试使用连接字符串打开MS Excel，但消息显示无效参数。我有什么想念？

  SELECT  * 
  FROM  [Provider = Microsoft.Jet.OLEDB。 4 。 0 ;数据源= C：\ Test.xls; 
扩展属性= Excel  8 。 0 ]。[Sheet1 $] 

解决方案

如果您不必以编程方式进行，那么请使用数据导入向导... http ：//office.microsoft.com/en-gb/excel-help/import-excel-data-to-an-access-database-HP005200852.aspx [ ^ ]



如果你必须在VBA中这样做，那么看看这里 http://www.rqna.net/qna/zrypm-import-data-from-excel-into-ms-access-closed.html [ ^ ]



或者这可能有效（不能测试，因为我不能拥有所有正确的版本）

 SELECT * FROM [Excel 8.0; HDR = YES;数据库= C：\Test.xls] [表Sheet 1 

Do you know how to import the data from MS Excel into MS Access? I tried to use connection string to open MS Excel but the message says "Invalid Argument". What do I miss something?

SELECT *
FROM [Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Test.xls;
Extended Properties=Excel 8.0].[Sheet1$]

解决方案

If you don''t have to do it programatically then use the data import wizard ... http://office.microsoft.com/en-gb/excel-help/import-excel-data-to-an-access-database-HP005200852.aspx[^]

If you must do it in VBA then have a look here http://www.rqna.net/qna/zrypm-import-data-from-excel-into-ms-access-closed.html[^]

Or this might work (can''t test as I don''t have all the right versions)

SELECT * FROM [Excel 8.0; HDR=YES; Database=C:\Test.xls].[Sheet1

这篇关于MS Access - 如何从MS Excel导入数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！