I am trying to import data from Excel 2007. SQL Server 2008 using a TSQL OpenRowset command with the Microsoft. ACE. OLEDB. 12. 0 OLE DB provider. Hi, Could you help me, please I need to every month to import data from Excel file to Sql Server table. Both, Excel and SQL table there are the same nametype of. Learn, Share, Build. Each month, over 50 million developers come to Stack Overflow to learn, share their knowledge, and build their careers. Join the worlds. Like linked servers, OPENROWSET and OPENDATASOURCE use OLE DB to connect to the remote data source however, these functions do not encompass all the features. SQL Server Forums OPENROWSET OR BULK I tried to things 1 INSERT INTO dbo. SELECT FROM OPENROWSETBULK c testbulk. SINGLEBLOB AS x. For that I received the msg Msg 1. Level 1. 5, State 1, Line 1. The select list for the INSERT statement contains fewer items than the insert list. The number of SELECT values must match the number of INSERT columns. But I count 8 columns in the table and in the excel file. BULK INSERT dbo. finldgtest FROM c testbulk. Wapking In Serial Songs Download there. WITH CODEPAGE 8. For that I received the messager Msg 4. Level 1. 6, State 1, Line 1. AE_Ln8B4f5k/T7ATuvfk4JI/AAAAAAAAASc/IZrw8sIN2zk/s1600/erro_tabela_corrigido.jpg' alt='Could Not Find Installable Isam Openrowset' title='Could Not Find Installable Isam Openrowset' />How to use Excel with SQL Server linked servers and distributed queries. XEFY0/T7AR6_NQFyI/AAAAAAAAAR0/BpLnlA5J9oM/s1600/sqlserver.jpg' alt='Could Not Find Installable Isam Openrowset' title='Could Not Find Installable Isam Openrowset' />Bulk load data conversion error type mismatch or invalid character for the specified codepage for row 1, column 1 Year. Msg 4. 86. 4, Level 1. State 1, Line 1. Bulk load data conversion error type mismatch or invalid character for the specified codepage for row 2, column 1 Year. Msg 4. 86. 4, Level 1. State 1, Line 1. Bulk load data conversion error type mismatch or invalid character for the specified codepage for row 3, column 1 Year. The first line in my excel i have 2. Jan 7. 57 LDG Active NULL 0. I dont know what I did wrong. I would like to import data from excel file.