.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
satyapriyanayak
Post New Web Links

Import Excel File to Sql Server on a 64 bit machine

Posted By:      Posted Date: October 25, 2010    Points: 0   Category :Sql Server
 

I need to import Excel (xls - 2003-2007) data into a Sql Server 2008 database. Both the Excel file and the database live on a Windows Server 2003 R2 sp2 64 bit machine.  I’m fine with it running in 32 bit mode but it all needs to happen on the same server. Also, I would like it to run in T-Sql but as a fallback we can do this in SSIS.

My T-Sql code which runs fine on a 32 bit machine is as follows:

SELECT * Into #TempTable From OpenRowSet('Microsoft.Jet.Oledb.4.0','Excel 8.0;Database=\\Servername\Folder\filename.xls;HDR=NO;IMEX=1', 'select * from [Main$]')

 

On the 64 bit server:


View Complete Post


More Related Resource Links

Import Excel File in SQL Server

  

Dear all,

I have to create one page where user will upload the excel file in SQl Server and system should check following things

1.Sheet Name should be always sheet1

2.System should check the column names

3.System should show the message that these many rows has been loaded

Thanks,

 


Import Excel-File (OPENROWSET) on x64 SQL Server

  

Hi, recently I encountered the following problem:

I tried to execute a stored procedure on the newly installed SQL 2005 Server (now on x64 Win Server 2003) which imports an Excel-File into a DB table.

We use OPENROWSET to access the Excel data. But I recognized this is dependent on Jet OLE DB which seems is not available for x64 windows.

 

Is there another way to import excel data using a stored procedure.

 

thank you in advance, rene


Insert Excel Data via File Upload into sql server database???

  
Hi all, I have requirement that User can Upload the Excel Sheet Data to sql server Database at once. How i do that Any Article or hint is apperciated.   Regards 

Saving Image File in a Folder on Sever from Client Machine using Sql Server

  
  Hi EveryOne... Can anyone help me Saving an Image file in a Server folder from a client machine using Sql server 2005....   

Import Excel data into SQL Server express 2008

  
I have recently installed SQL express 08 and created a table to import excel data into.  Im running on a windows 7 64 bit OS i5 processor.  I've disabled the firewall (temporarily) and will set the necessary ports once this is working. I run the following query:  (which i found from multiple sources on the net) Select   * From OPENROWSET ( 'Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\Users\Public\lenovoBkup\contacts\outlookFiles\noib2a.xls', 'Select * From [sheet1$]' )  and receive the following message: Msg 7308, Level 16, State 1, Line 1                                                                                  OLE 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.  (how did they know i was single and living in an apartment? lol) so after research of the following message i restarted the system and relaunched man

Accessing image file in local machine from server

  
 Hi i have a  .JPG file in my local machine which has  to be sent as body of SMTP mail. Path of image D://foldername//imagename.jpg The code I run is in the server m\c. I want it to access my local machine's d:\ folder to get the image file. But it is accessing the server m\c's d:\ folder. How can this be done? Thanks Amuda.RG  

importing excel file into sql server 2005 in asp .net using c#

  
Dear friends i want to import excel file into sql server 2005 in asp .net using c# can anyone help me? rgds,RK

How to import Data from Excel to SQL Server Express

  
 Hi,  please any one is expert in Data Base help me, i would like to import two Data columns from Excel file 2003 instead of two columns in a table in Sql Server Express 2005 , How Can i do that? and what is the way if I have Sql Developer 2005, thank you .  

run dtexec on server from batch file on client machine

  
Hi I would like to enable a user to execute an SSIS (2005) package located on a server.  The client does not have any elements of SQL server installed on his machine so he cannot execute the package locally.  At present he has to remote connect to the server and double click a batch file on the server that contains the dtexec script. I would like to have a batch file located on the client desktop that he can click, that will run the dtsexec script on the server - as it will not work from the client machine.  However every set of commands i try inevitably end up trying to run the package on the local machine, which obviously fails. Is there any way to have the client kick of the package and have it run on the server, without him actually having to directly remote desktop to the client? Thanks  Guy

data type problem in import data from excel file

  

Dear All,

I am importing the data from excel file using following code.

connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(strFolderFileName) & ";Extended Properties=HTML Import;"
                conn = New OleDbConnection(connstr)
                Dim strSQL As String = "SELECT * FROM [" & strWorkSheetName & "]"

                Dim cmd As New OleDbCommand(strSQL, conn)

                Dim da As New OleDbDataAdapter(cmd)
                da.Fill(datatable)


Now the problem is if a coulmn vlaue start with a number value like "15" then the other string value like "W15" in that column is ignored in the datatable.

eg. The excel column value     Column1

                       &n

Import Excel to SQL Server

  
Hi, I want to import spreadsheet from network computer to SQL Server 2008 R2 database, I want to each user can write to database easly their data from excel spreadsheet in real-time, and can refresh their spreadsheet with the new data.

Can explain me how to do this and send me code to try ?

Thanks.


can I use SQL Server to export an excel file directly?

  

I just want to know except use owc

can we use SQL Server to export excel file ?

if it can be , how to do? thanks alot


Trying to import from Excel file

  

I have been trying to import from an Excel file and insert it into a table.

I can upload the Excel file

I can view the Excel file in a grid

But when I run the import process to insert the rows in the Excel file I get only one row and it has all nulls except the dateentered and entered by field.

I added breakpoints and tried setting a couple of the fields to labels and I could see that data was getting to the reader.

So now I hoping someone might see something I'm missing here.

Protected Function ExcelConnection() As OleDbCommand

        ' Connect to the Excel Spreadsheet (online) = .ACE.OLEDB.12.0 (local) = .Jet.OLEDB.4.0
        Dim xConnStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
                    "Data Source=" & Server.MapPath("~/Import_Process/ExcelImport_vol.xls") & ";" & _
                    "Extended Properties=Excel 8.0;" 'HDR=NO;IMEX=1"

        ' create your excel connection object using the connection string
        Dim objXConn As New OleDbConnection(xConnStr)
        objXConn.Open()

        ' use a SQL Select command to retrieve the data from the Excel Spreadsheet
        ' the "table name" is the name of the worksheet within the spreadsheet
        ' in this case

Import list from excel file

  

Hi,

I try import a table from excel file to become a SharePoint list.

I want the first column in the excel to become the title column (linked to item).

I did some tests and in each tests it tooks a different column of the excel to be the sharepoint column which is "linked to item with edit menu".

What is the logic and how may i control which excel column will be that sharepoint column?

thanks


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend