Can't read exported XLS files with Jet's OLEDB

Technical support for Spire.DataExport

Moderators: iceblue support, DataExport, Manager

Can't read exported XLS files with Jet's OLEDB

Postby waynegoode » Thu Oct 16, 2008 9:34 pm

I can't read sheets exported by Spire.DataExport with Jet's OLEDB provider unless I first open & save the file with Excel.

When I first asked this question, I thought the problem was that multiple tabs were selected when the file was saved. Opening the file, selecting one tab and then closing the file solved the problem. However, it was opening & saving the file that solved the problem, no the selection of only one tab.

My code to read the XLS file:


Code: Select all
Dim conn As New OleDbConnection
Dim cmd As New OleDbCommand
Dim dap As OleDbDataAdapter
Dim dt As SampleDataTable

conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=""C:\sample.xls"";Extended Properties=""Excel 8.0;"""

cmd.CommandText = "SELECT * FROM [Sample$]"
cmd.Connection = conn
dap = New OleDbDataAdapter(cmd)

With conn
   .Open()
   dt = new SampleDataTable
   dt.Clear()
   dap.Fill(dt)
   .Close
End With


More info about reading Excel files in VB.NET using OLEDB can be found here: http://www.codeproject.com/KB/office/excel_using_oledb.aspx
waynegoode
 
Posts: 1
Joined: Thu Oct 16, 2008 9:23 pm

Postby DataExport » Thu Nov 06, 2008 7:45 am

Hello,

If you want to read/write excel file without OLE, please try to using Spire.XLS.
For more detailed information,
http://www.e-iceblue.com/xls/xlsintro.htm
DataExport
 
Posts: 35
Joined: Thu Jun 29, 2006 2:29 pm


Return to Spire.DataExport

Who is online

Users browsing this forum: No registered users and 0 guests