Import Excel Data Into Sql Table

Aug 20, 2007

Hi!
I have to develop an application for transfering data from an excel file into a sql table.The excel file is uploaded to a server.The database(and the table) is on another server.At first,I used openrowset for transferring data to the table.My sql command looked like this(in my asp page):

SQLstr = "SELECT * INTO dbo.shopping_TSR FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database="+Server.MapPath("upload/tmb2.xls")+";hdr=yes', 'SELECT * FROM [Sheet1$]')"

I kept getting this error:
[Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the error.]

After reading a few articles,I think the cause of my error is that the excel file is uploaded into the folder where the asp script is located.I have 2 servers : one running the asp scripts and one containing the database.
Is my error generated by the fact that the excel file is on a different server than the sql server?How could I make this work?


View 4 Replies


ADVERTISEMENT

How Do Create Table From Excel (based On Excel Column Name) And Import Data From It?

Jun 14, 2006

l've the following situation,

l've some excel files controlled by Vendor which changing frequently. The only thing does not change is the header name of each column.

So my question is, is there any way to create a new table based on the excel file selected including the column name in SSIS? So that l can use the data reader as source to select those columns l am interested on and start the integration.


Thanks.

Regards,
Yong Boon, Lim


p/s : The excel header is at the row 7.

View 3 Replies View Related

Import Excel Data To --&> SQL Db Table

Oct 8, 2007

Hey folks,
My first post and I hope not my last!!

I am very new to the entire world SQL Server databases. I am starting from scratch.

Currently I have a little Website I am doing for myself that is .asp based and will allow users to query some sports boxscores. I hope to create a user interface that will allow folks to seperate team results based on certain criteria...

It is just a hobby of mine that I have been doing for year with excel and now hope to let others like me do it aswell.

here is what I got.

MSSQL 2005 Server with a database.
Iam using SQL 2005 Server Express Studio. Therefore, do not have access to SSIS or DTS or anything like that.

However, I want to import several hundred records into a db I created (hosted by Crystal tech). Since, I don't have access to the Server root directory, I can't use the BULK INSERT statement.

I am looking for a method to query an excel file (or .csv something..) that is stored on my local drive and upload it to the Server db tables.

I would like to do this either through SQL with a query. Or I would to add this VB code to the current VB that I use in my Excel file.

any ideas..??

Thank you for supporting me in advance.

View 8 Replies View Related

Data Import From Excel To Sql 2000 Db Table

Feb 26, 2008

i have a table in sql 2000 db and want to import data from excel sheet in to the table.
my table = Table1
excel file = data.xls
is there a simple method where i can import data from the sheet into the existing table?

View 5 Replies View Related

Import Data From Excel Spreadsheet Into A Table

Jul 17, 2013

I am using the import wizard in SQL Server 2008 R to import data from an Excel spreadsheet into a table I have created.

The spreadsheet contains 3 columns that SQL recognises as DOUBLE and they contain a 1 or 0. What data type do the corresponding fields in SQL table need to be? I have tried BIT, INT and FLOAT but keep getting an error (can't view details of the error because I get chucked out every time the error pops up). I know the problem is with the DOUBLE data because when I 'ignore' those columns the import works fine.

View 2 Replies View Related

Import Excel Data Sheet To SQL Table - How To ??

Mar 18, 2006

I need to make a script in SQL 2005 to import data from an Excel sheet into a SQL table.
I am using the wizard to import now.
Import from Excel 2000. First row of the excel sheet has column names.
Excel file name is: EXL.xls, sheet name is: Sheet1
Destination sql database name is: NM, table name is: Sht1
I use SQL Server Authentication to access the database.
User name: ABC and password: DEF
Database name is: DB
I am using the following setting when importing now:
- Delete rows in destination table
- Enable identity insert

View 3 Replies View Related

Import Excel Data To A Sql Server Table

Sep 11, 2007

Hi,

I need to import data from more than 10 excels having the same format in to a single sql server table.

I tried to use

INSERT INTO MyTempTable
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 11.0;Database=C:Book1.xls', [Sheet1$])

but got the below error
Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0' has been denied. You must access this provider through a linked server.

If DTS package is used then I am not sure how I can place 10 excels at a time so that they can be picked one by one and data is imported in to table.

Please help.

Thanks,
Vimalraj

View 1 Replies View Related

Import Data From Excel Into Existing Table....

Nov 27, 2007

Hi guys, I need to import all data from Excel spreadsheet to a Sharepoint Content Database (SQL Server).Please suggest the
best way to do this.
For this when i run the Import wizard under Tasks--> Import in Management Studio 2005 ....it asks me to choose the database
name etc....but How to use the Import/Export Wizard to Export Data from a .xls source to an existing table in a database....that is i need to append/insert my excel data into an existing table.

Thanks,
Kon

View 2 Replies View Related

Data Conversion Errors On Excel Import Into Existing Table

Aug 28, 2006

Recently installed Sql Server 2005 client and am now attempting to import data from a spreadsheet into an existing table. This works fine with Sql Server 2000 but I am getting data conversion truncation errors that stop the process when this runs using import utility in Sql Server 2005.

Any help would be appreciated.

View 1 Replies View Related

Import Excel Spreadsheet Data Into SQL Server Database Table Using SqlBulkCopy

Dec 13, 2007

 
Hi, I'm a Student, and since a few months ago I'm learning JAVA. I'm creating an application to call and compare times. For this I create in Excel a time table which is quite big and it would be a lot of typing work to input one by one the data in each cell in SQL Server, considering that I have to create 8 more tables. I was able to retreive the data from excel usin the JXL API of JAVA but it doesn't give all the funtions to perform math operations as JDBC. That's why I need to move the tables from Excel to SQL.
I found this site http://davidhayden.com/blog/dave/archive/2006/05/31/2976.aspx which gives a code to do so, but I guess that some heathers are missing or maybe I don't know which compiler to use to run that code, I would like you help to identify which compiler use to run that code or if there is some vital piece of code missing.// Connection String to Excel Workbook
string excelConnectionString = @"Provider=Microsoft .Jet.OLEDB.4.0;Data Source=Book1.xls;Extended Properties=""Excel 8.0;HDR=YES;""";

// Create Connection to Excel Workbook
using (OleDbConnection connection = new OleDbConnection(excelConnectionString))
{
OleDbCommand command = new OleDbCommand ("Select ID,Data FROM [Data$]", connection);

connection.Open();

// Create DbDataReader to Data Worksheet
using (DbDataReader dr = command.ExecuteReader())
{
// SQL Server Connection String
string sqlConnectionString = "Data Source=.; Initial Catalog=Test;Integrated Security=True";

// Bulk Copy to SQL Server
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlConnectionString))
{
bulkCopy.DestinationTableName = "ExcelData";
bulkCopy.WriteToServer(dr);
}
}
}
On the other hand in this forum I that someelse use that link but implements a totally different code which I'm not able to compile also http://forums.asp.net/p/1110412/2057095.aspx#2057095. It seems this code works as I was able to read, but I do not know which language is used.
Dim excelConnectionString As String = "Provider=Microsoft .Jet.OLEDB.4.0;Data Source=Book1.xls;Extended Properties=""Excel 8.0;HDR=YES;"""
 
' Using
 
Dim connection As OleDbConnection = New OleDbConnection(excelConnectionString)
 
Try
 
Dim command As OleDbCommand = New OleDbCommand("Select ID,Data FROM [Data$]", connection)
connection.Open()
 
' Using
 
Dim dr As DbDataReader = command.ExecuteReader
 
Try
 
Dim sqlConnectionString As String = WebConfigurationManager.ConnectionStrings("CampaignEnterpriseConnectionString").ConnectionString
 
' Using
 
Dim bulkCopy As SqlBulkCopy = New SqlBulkCopy(sqlConnectionString)
 
Try
bulkCopy.DestinationTableName =
"ExcelData"
bulkCopy.WriteToServer(dr)
 
Finally
 
CType(bulkCopy, IDisposable).Dispose()
 
End Try
 
Finally
 
CType(dr, IDisposable).Dispose()
 
End Try
 
Finally
 
CType(connection, IDisposable).Dispose()
 
End Try
 
Catch ex As Exception
 
End Try
The Compilers I have are: Eclipse, Netbeans, MS Visual C++ Express Edition and MS Visual C# Express Edition. In MS Visual C++
Thanks for your help.
 Regads,
Robert.
 

View 4 Replies View Related

SQL Server 2014 :: Import Data From Excel To Table - Null Instead Of 0 In Columns

Oct 29, 2013

I have a excel sheet with some data and blank columns. I have a ssis package using to import data from excel to sql table. For blank excel columns it is importing as null instead i want to show them as '0'. If data comes in it should update the data.

View 8 Replies View Related

SQL 2012 :: Using Excel In SSIS To Import Data From Spreadsheet To Staging Table?

Feb 5, 2015

I'm trying to use Excel in SSIS to import the data from spreadsheet to a staging table. The package runs well from the web server using SSMS. But when I deploy and try to execute the package, I'm getting the below error. I've a question, whether I've to install the AccessDatabaseEngine driver in SQL database server or the web server where I'm executing the SSIS?

Error: The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode.

View 3 Replies View Related

Import From Excel To More Than One Db Table

Feb 7, 2008

Hi,

I have a large excel file that contains some contact information and includes the following columns:
Company Name, Company Fax, Company Address, Contact Person

In the db I have 3 tables that I need to insert into:
Company table
id ([uniqueidentifier] NOT NULL DEFAULT (newid())
Company Name nvarchar (200)
Company Fax nvarchar (200)
Company Address nvarchar (200)

Contact table
id ([uniqueidentifier] NOT NULL DEFAULT (newid())
Contact Name nvarchar (200)

Contact_Company table
id ([uniqueidentifier] NOT NULL DEFAULT (newid())
contact_id [uniqueidentifier] NOT NULL,
company_id [uniqueidentifier] NOT NULL,


In addition, the excel file will contain the company name more than once (for every contact person in company new row with company name).
I need to insert into table Company the company only once.
I then need to insert the Contact details into the table Contact
Finally, i need to insert into Contact_Company table both the company_id and contact_id

Problems:
-How do i insert into Company table the company only once from excel?
-How do i insert into Contact_Company the correct contact_id and company_id so that the right contact person will be assigned to the company?

Thanks for the help




Whisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much.

View 3 Replies View Related

Import From Excel To More Than One Table

Feb 8, 2008

Hi,

I have a excel file that contains some contact information and includes the following columns:
Date, Name, Address, Zip, City and phone

In the db I have 2 tables that I need to insert into, the statment of the first table is:

CREATE TABLE [TMsalg].[SQLUser].[tbl_Customer] (
[CustomerID] int NOT NULL,
[Name] varchar (50) NULL,
[Adress] varchar (100) NULL,
[ZipCode] varchar (50) NULL,
[City] varchar (50) NULL,
[Phone] varchar (50) NULL
)

and the other statment is:
CREATE TABLE [TMsalg].[dbo].[Order_Ernering] (
[OrderID] int NOT NULL,
[Customer_id] int NULL,
[Name] nvarchar (100) NULL,
[Adress] varchar (100) NULL,
[ZipCode] varchar (10) NULL,
[City] varchar (100) NULL,
[Phone] varchar (10) NULL,
)

Problems:
-How do i insert into tbl_Customer table the custom only once from excel?
-How do i insert into Contact_Company the correct customer_id and company_id?

Thanks for the help

View 4 Replies View Related

Import Data From Excel-Sheet Via OleDb In VB.Net - How To Get A Columns Data As String?

Oct 25, 2007

Hello,

i want to import data from an excel sheet into a database. While reading from the excel sheet OleDb automatically guesses the Datatype of each column. My Problem is the first A Column which contains ~240 Lines. 210 Lines are Numbers, the latter 30 do contain strings. When i use this code:







Code BlockDim sConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & conf_path_current & file_to_import & ";Extended Properties=""Excel 8.0;HDR=NO"""
Dim oConn As New OleDb.OleDbConnection(sConn)
Dim cmd1 As New System.Data.OleDb.OleDbCommand("Select * From [Table$]", oConn)
Dim rdr As OleDb.OleDbDataReader = cmd1.ExecuteReader
Do While rdr.Read()
Console.WriteLine(rdr.Item(0)) 'or rdr(0).ToString
Next




it will continue to read the stuff till the String-Lines are coming.
when using Item(0), it just crashes for trying to convert a DBNull to a String, when using rdr(0).ToString() it just gives me no value.

So my question is how to tell OleDB that i want that column to be completly read as String/Varchar?

Thanks for Reading

- Pierre from Berlin


[seems i got redirected into the wrong forum, please move into the correct one]

View 1 Replies View Related

Transact SQL :: Excel Data Import Truncate Data Length To 255

Jul 29, 2015

I am trying to import data from an excel Sheet to SQL Database using OPENROWSET. After import I found that all the cells containing data of more than 2000 length got truncated to  255 characters only. I tried finding the solution and found that We need to have the data with length more than 255 in first 8 rows of Excel sheet. It worked for me also. But In real scenario the data that I cant do the manual work on excel. I tried out with Dot Net utility and SSIS package also but the truncation is still the issue.

INSERT into tmp_Test
SELECT
*
FROM
OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel
12.0;Database=D:Book1.xlsx', [Sheet1$])

View 9 Replies View Related

How To Import Data From Excel Into MS SQL In .Net?

Jun 15, 2007

Hi, I'm building a web application in VB.NET 1.1 where users will upload Excel files at this webpage and the web application will transfer the data from the uploaded Excel file into MS SQL 2000. There are around 600-700 records and about 56 columns in the Excel file which is to be uploaded daily. There will be a few different files which I need to implement for as well.
 I've sourced for and tried alot of methods. But either they can't satisfy my requirements or they just can't simply work.
- Most simple and direct way I've tried is creating a oledb connection to the Excel file in the following codes...
Function TestUploadData1(ByVal vFile As String) As String    Dim Oleda As System.Data.OleDb.OleDbDataAdapter    Dim Olecn As System.Data.OleDb.OleDbConnection    Dim dt1 As DataTable
   Olecn = New System.Data.OleDb.OleDbConnection( _ "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & vFile & ";" & _ "Extended Properties=Excel 8.0;HDR=Yes")    Olecn.Open()
   Dim ExcelCommand As New System.Data.OleDb.OleDbCommand("SELECT INTO [ODBC;Driver={SQL Server};Server=(local);Database=dbSSC;Trusted_Conn ection=yes].[tblOutstanding] FROM [Report$];", Olecn)    ExcelCommand.ExecuteNonQuery()
   Olecn.Close() End Function
But from the above codes I kept getting the error "Could not find installable ISAM." at the line Olecn.Open(). I've tried to set the registry to C:WindowsSystem32msexcl40.dll but to no avail...
- I've tried another method using the OpenRowSet in the following codes Function TestUploadData2(ByVal vFile As String) As String    Dim cn As SqlConnection    Dim cm As SqlCommand    Dim strSQL As String cn = New SqlConnection("server=localhost; user ID=accessSSC; password=accessSSC541; database=dbSSC")
   cn.Open()
   strSQL = "INSERT INTO tblOutstanding SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=" & vFile & ";HDR=Yes','SELECT * FROM [Report$]')"    cm = New SqlCommand(strSQL, cn)    cm.ExecuteNonQuery()
   cn.Close() End Function
For the above codes, I kept getting the error "Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0' has been denied. You must access this provider through a linked server." at the line cm.ExecuteNonQuery() and I've tried to disable the Ad Hoc settings in the registry and tried to create a link server but to no avail as well...
- I've tried DTS but I'd need to DTS package to run whenever the users upload a file. Is there an easy way that I can run the designated DTS package to run through my .Net web application?
Any help would be deeply appreciated. Thanks & Regards, Keith Chang

View 8 Replies View Related

Import Data From Excel

Feb 9, 2004

Hi:

I imported data from Excel to a table on SQL Server throught Data Transformation Services.

All data with a under score(like 1_5, 7_5) were replaced by Nulls. Is there any comment

about that?

Thanks a lot!

Regards,

Kevin Jin

View 6 Replies View Related

Import Data From Excel To MS SQL Using DTS

Feb 10, 2005

Hi guys,
I need to import data from excel to MS SQL table, but I already have data in MS SQL table, I just want to update one column.
How can I do that?

View 1 Replies View Related

SQL '05 Import Excel Data

Jun 9, 2007

Hi,

On SQL 2005 I am trying automatically through the import 'wizard' import data from excel into an existing table that I have created. I can't find a way to do this without creating a new table. Any takes?

View 5 Replies View Related

Import Data From Excel

Jun 18, 2007

How to create SSIS Package to import data from excel

View 2 Replies View Related

Import Data From Excel To Sql

Aug 16, 2007

Hi!
I'm trying to import data from an excel file into a sql table.I'm using MS SQL.For import,I use openrowset.The SQL command looks like this(in my asp page):


SQLstr = "SELECT * INTO dbo.shopping_TSR FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database="+Server.MapPath("\fileuploader\upload\tmb2.xls")+"', 'SELECT * FROM [Sheet1$]')"


I'm getting the following error:
[Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the error.]

What could be the cause of this error?
The .xls file and the sql table are on differen t servers.

Can anyone help?

Thanks in advance.

View 1 Replies View Related

Import Data From Excel Into Ms Sql

Aug 16, 2007

View 2 Replies View Related

Import Data From Excel?

Apr 20, 2006

Hello,

I have an Excel spreadsheet that I am loading data from and I want to prevent SSIS from making assumptions about the data contained within the spreadsheed and to just treat every column as a string (i.e. Unicode string [DT_WSTR]). How is this done?

I know I could do a conversion once the data is loaded, but I am wondering if there is a way to specify this in the Excel Source settings without having to add a Data Conversion task to the Data Flow.

TIA...

View 3 Replies View Related

Import Data From Excel To Sql

Sep 23, 2007

hi there

can I get help about import data from excel sheet to sql server by C#?
from excel to xml and from xml to sql server? or excel to sql directry?

thanks for your fast response.
waeldief@msn.com

View 2 Replies View Related

Import Excel Spreadsheets Into One Table

May 1, 2014

How can I use code (wither it be SQL or .Net Framework) to programmatically import 8 different Excel Sheets into One SQL Table (that currently does not exist)?

This is SQL Server 2005. Excel 2007.

View 14 Replies View Related

Import Excel File Into Table Via T-SQL?

Jun 6, 2008

Hi folks. I am having an excel file. I need to import this file to database and update some other tables with data contained in this file. I would like to automate this process as much as possible.
Now, I am just using SQL Server Import Wizard to create a table and then I am running an update query. Is there any (more automate) way to do this?

Thanks for your time.

View 3 Replies View Related

Import Excel From Local To DB Table?

Jul 15, 2014

I wanna to import excel from local to DB table.

Excel will be in one server and DB will in another server.this import should be scheduled.

How to achieve this.My friend suggest to use SSIS.how to use SSIS for this.

View 1 Replies View Related

Import From Excel To Exsisting Table

Jul 26, 2007

Hi,

I am trying to import data from an excel table into an existing table. Also there are more columns in the table than in the excel sheet.
I am not sure how to import to an existing table. Also during the import i have to add 9999 to the existing EmployeeID in the excel file.

Columns in the excel file:
EmployeeID
DepartmentName
UserName
FirstName
LastName
Email
WorkPhone
UserPassword
Active

Structure of the User_sys table in sql:
CREATE TABLE [dbo].[Users_sys](
[User_id] [bigint] NOT NULL,
[USer_name] [nvarchar](50) NULL,
[Given_Names] [nvarchar](50) NULL,
[Surname] [nvarchar](50) NULL,
[Email] [nvarchar](50)NULL,
[Phone_no] [nvarchar](50) NULL,
[Password] [varchar](50)NULL,
[Role_code] [nvarchar](50)NULL,
[Candidate_id] [int] NULL CONSTRAINT [DF_Users_sys_Candidate_id] DEFAULT ((0)),
[Business_admin] [bit] NULL CONSTRAINT [DF_Users_sys_Business_admin] DEFAULT ((0)),
[Active] [bit] NULL CONSTRAINT [DF_Users_sys_Active] DEFAULT ((0)),
[NotActive_date] [datetime] NULL,
[Activation_date] [datetime] NULL,
[Date_Entered] [datetime] NULL,
[User_Id_Ent] [int] NULL CONSTRAINT [DF_Users_sys_User_Id_Ent] DEFAULT ((0)),
[Date_Updated] [datetime] NULL,
[User_Id_Upd] [int] NULL CONSTRAINT [DF_Users_sys_User_Id_Upd] DEFAULT ((0)),
CONSTRAINT [PK_Users Table_sys] PRIMARY KEY CLUSTERED
(
[User_id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]


Whisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much.

View 1 Replies View Related

SQL Server Import And Export Wizard Fails To Import Data From A View To A Table

Feb 25, 2008

A view named "Viw_Labour_Cost_By_Service_Order_No" has been created and can be run successfully on the server.
I want to import the data which draws from the view to a table using SQL Server Import and Export Wizard.
However, when I run the wizard on the server, it gives me the following error message and stop on the step Setting Source Connection


Operation stopped...

- Initializing Data Flow Task (Success)

- Initializing Connections (Success)

- Setting SQL Command (Success)
- Setting Source Connection (Error)
Messages
Error 0xc020801c: Source - Viw_Labour_Cost_By_Service_Order_No [1]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0014019. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
(SQL Server Import and Export Wizard)

Exception from HRESULT: 0xC020801C (Microsoft.SqlServer.DTSPipelineWrap)


- Setting Destination Connection (Stopped)

- Validating (Stopped)

- Prepare for Execute (Stopped)

- Pre-execute (Stopped)

- Executing (Stopped)

- Copying to [NAV_CSG].[dbo].[Report_Labour_Cost_By_Service_Order_No] (Stopped)

- Post-execute (Stopped)

Does anyone encounter this problem before and know what is happening?

Thanks for kindly reply.

Best regards,
Calvin Lam

View 6 Replies View Related

Data Import Excel XML Defaults Which File Governs Excel Defaults?

Jul 21, 2015

I'm importing a multi tab spreadsheet using Import wizard, which I understand to use the same internals as SSIS. The total number of columns in the spread sheet will be over 500. The import wizard defaults everything to varchar 255. I understand there is an XML file I can manipulate to change this and they are located

C:Program FilesMicrosoft SQL Server100DTSMappingFiles

Assuming one of these will control Excel defaults, which one is it? None of the names lend themselves to the Excel as a source. SqlClientToMSSql10?

View 6 Replies View Related

Import Data Through Excel File

Mar 3, 2008

 
hii all,
        i've to import bulk data from excel file to sql server 2000 , i'm using asp.net 1.1 with C# and i've to make a front end(windows application) for this.
help me out if any1 knows that...
Thanks & Regards
anant vijay

View 2 Replies View Related

Import Excel Data Into Sql Express

May 19, 2008

hi,
i need to import excel data(2000 records) into sql server table.
i did all possible ways. but still i am getting the error
 
 
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Could not find installable ISAM.".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".
 
i used the query SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data Source=C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLdata.xls;Extended Properties=Excel 11.0',HDR=YES,Sheet1$)
 
and also
SELECT *
FROMOPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', 'Data Source=C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLdata.xls;
Extended Properties=''Excel 11.0''')...[Sheet1$]
 
but no luck
i have configured linked server through management studio express.
 
can any one suggest me how to achieve this.
is there any easy way
 
Thanks

View 28 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved