InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 04:23:30 GMT20http://www.sqlservercentral.com/Forums/Topic1407202-391-1.aspxafter installation of msaccess12.0 driver its working...:-)Fri, 18 Jan 2013 03:24:14 GMTsathiyan00http://www.sqlservercentral.com/Forums/Topic1407202-391-1.aspxMS office 2007 or 2010?windows 7 62 bit ?Please guide me ....Thu, 17 Jan 2013 21:57:57 GMTsathiyan00http://www.sqlservercentral.com/Forums/Topic1407202-391-1.aspxIt does work in R2 ; I have used openrowset in my project for adhoc insertions..Thu, 17 Jan 2013 06:49:18 GMTdemonfoxhttp://www.sqlservercentral.com/Forums/Topic1407202-391-1.aspxis it working for anyone . loading data in sql server 2008 r2(64 bit) from file(excel 2007,text file) using sql.....Thu, 17 Jan 2013 03:19:32 GMTsathiyan00http://www.sqlservercentral.com/Forums/Topic1407202-391-1.aspxHere is another syntax for your consideration:[u][url=http://www.sqlservercentral.com/Forums/FindPost1407497.aspx]http://www.sqlservercentral.com/Forums/FindPost1407497.aspx[/url][/u]Wed, 16 Jan 2013 08:20:27 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1407202-391-1.aspx[quote][b]Lokesh Vij (1/15/2013)[/b][hr]humm... Try this out thenExecute this first:[code="sql"]EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 1GOEXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DynamicParameters', 1GO[/code]Then try to execute your query with this change:[code="sql"]SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 8.0;Database=C:\Users\sathiyanr\Desktop\dynamic.xlsx','SELECT * FROM [Sheet1$]')[/code][/quote]How about this one Lokesh :[code="sql"]EXEC sp_addlinkedserver @server = N'ExcelDataSource', @srvproduct=N'ExcelData', @provider=N'Microsoft.ACE.OLEDB.12.0', @datasrc=N'C:\DataFolder\People.xlsx',@provstr=N'EXCEL 12.0' ;SELECT col1,col2 FROM OPENQUERY(ExcelShare, 'SELECT * FROM [Sheet1$]')[/code]I guess It can be used; when a particular excel is frequently used and has a plenty of sheets :)(I use it for side testing ; just another way to accessing excel .)Wed, 16 Jan 2013 02:36:15 GMTdemonfoxhttp://www.sqlservercentral.com/Forums/Topic1407202-391-1.aspxThe ACE drivers are not standard equipment on Windows Server 2008 so in case you;re looking for them you can download a 32 or 64-bit version here:[u][url=http://www.microsoft.com/en-us/download/details.aspx?id=13255]http://www.microsoft.com/en-us/download/details.aspx?id=13255[/url][/u]Tue, 15 Jan 2013 23:48:27 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1407202-391-1.aspxhumm... Try this out thenExecute this first:[code="sql"]EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 1GOEXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DynamicParameters', 1GO[/code]Then try to execute your query with this change:[code="sql"]SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 8.0;Database=C:\Users\sathiyanr\Desktop\dynamic.xlsx','SELECT * FROM [Sheet1$]')[/code]Tue, 15 Jan 2013 06:54:53 GMTLokesh Vijhttp://www.sqlservercentral.com/Forums/Topic1407202-391-1.aspxI already tried this one lokesh....but no change...Tue, 15 Jan 2013 06:17:34 GMTsathiyan00http://www.sqlservercentral.com/Forums/Topic1407202-391-1.aspxTry to execute the following set of commands and check if this works:[code="sql"]sp_configure 'show advanced options', 1;GORECONFIGURE;GOsp_configure 'Ad Hoc Distributed Queries', 1;GORECONFIGURE;GO[/code]Tue, 15 Jan 2013 06:12:59 GMTLokesh Vijhttp://www.sqlservercentral.com/Forums/Topic1407202-391-1.aspxHi all, Is that possible to select The data from excel 2007 on sql server 2008 r2(64 bit),os Windows 7 (64 bit)Using Sql?I used Following query but it throws errorSELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\Users\sathiyanr\Desktop\dynamic.xlsx', 'SELECT * FROM [Sheet1$]')Error:Msg 7308, Level 16, State 1, Line 1OLE DB provider 'Microsoft.Jet.OLEDB.4.0' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.Tue, 15 Jan 2013 05:47:17 GMTsathiyan00