No announcements
Found 3888888 threads
-
0 VotesHow to read excel File as it is displayed using OLEDB
As i mentioned before i have my code working properly but i am trying to find out if i can get the Displayed values from excel as opposed to stored values just like in VBA.Answered | 2 Replies | 3709 Views | Created by SSRSnewbee - Thursday, December 13, 2012 11:52 PM | Last reply by SSRSnewbee - Friday, December 14, 2012 4:12 PM
-
0 Votes
reading excel files using oledb
The Excel file I was using was a report automatically generated from a web application.Answered | 10 Replies | 5889 Views | Created by Sungmo Yeon - Friday, July 17, 2009 5:30 PM | Last reply by Sungmo Yeon - Friday, July 17, 2009 9:48 PM -
0 Votes
Read Excel File using OleDb
Hi, with this Excel C# / VB.NET library you can easily import Excel to DataSet with data conversion.Answered | 11 Replies | 20396 Views | Created by pczurak - Wednesday, September 1, 2010 9:24 PM | Last reply by CikaPero - Tuesday, May 10, 2011 8:44 AM -
2 Votes
Reading an Excel file without any dependancy on oledb provider or something else
As i tried oledb but didn't work because they don't have oledb provider.Answered | 19 Replies | 20996 Views | Created by NK sharma - Thursday, August 1, 2013 1:24 PM | Last reply by NK sharma - Friday, August 2, 2013 12:50 PM -
0 Votes
looking for alternative to jet oledb driver for reading data from excel files
In the end we decided to add support for excel 2007 and later using Open Office XML SDK.Answered | 6 Replies | 10224 Views | Created by nick.durcholz - Friday, March 30, 2012 2:17 PM | Last reply by nick.durcholz - Saturday, April 7, 2012 1:51 AM -
1 Votes
How to load an excel sheet into dataset using oledb
Then it's a matter of displaying the image when the data is retrieved.Answered | 3 Replies | 2626 Views | Created by VSTO Keen - Wednesday, February 8, 2012 8:03 AM | Last reply by J.Conrad - Friday, February 10, 2012 2:34 PM -
1 Votes
Exception on reading Excel file using OleDb
Yeah, it sounds like you need 12.0 for the ACE OLEDB Provider and 12.0 for Excel 2007/2010.Answered | 17 Replies | 13333 Views | Created by KevinBurton - Thursday, May 20, 2010 6:08 PM | Last reply by Prasanjit Mandal - Monday, June 28, 2010 11:35 AM -
0 Votes
Updating Excel using OLEDB
That's why I was required to use Excel APIs in these situations unfortunately.Answered | 5 Replies | 2025 Views | Created by Joseph Vin - Tuesday, September 25, 2012 9:13 AM | Last reply by Rajesh_Kannan - Friday, September 28, 2012 12:55 AM -
0 Votes
Excel data filtration using oledb from huge excel files size approx (200mb) using c# (ADO)
and even sql-server import-export wizard failed when i tried to import data from huge files.Answered | 5 Replies | 1662 Views | Created by Mr.'KING' - Friday, March 20, 2015 5:06 AM | Last reply by ryguy72 - Tuesday, March 24, 2015 3:04 PM -
1 Votes
Read an Excel File C# - OleDb VS Excel COM Objects
Consider storing your files in this format and using this component From a supportability perspective, Aspose Cells.NET and SpreadsheetGear ...Answered | 3 Replies | 7196 Views | Created by Kikeman - Tuesday, July 12, 2011 5:06 PM | Last reply by Kikeman - Tuesday, July 12, 2011 8:29 PM -
13 Votes
Appending Data in Bulk From .NET Oledb
The APPEND FROM command is not supported through OLEDB (even when using ExecScript and passing the SQL as paramter to a stored procedure).Answered | 26 Replies | 7356 Views | Created by mxcolin - Friday, November 19, 2010 11:45 PM | Last reply by mxcolin - Tuesday, December 7, 2010 10:00 AM -
10 Votes
Can I use Excel file to store data in the PC that Excel is not installed?
I'll edit data file manually using MS Excel and save it as .xls.Answered | 16 Replies | 871 Views | Created by Jeff0803 - Monday, December 3, 2018 8:27 PM | Last reply by Jeff0803 - Friday, December 7, 2018 3:56 AM -
1 Votes
Export to Excel Slow Using OleDB
I wonder if a schema.ini file will cause Excel to determine the correct datatypes?Answered | 13 Replies | 11568 Views | Created by jal2 - Wednesday, December 16, 2009 1:39 AM | Last reply by CikaPero - Friday, October 29, 2010 9:28 AM -
0 Votes
OLEDB writing to excel data types
CAST is a SQL Server internal function, while you are executing this against Jet OLEDB directly, there's no SQL involved.Answered | 7 Replies | 12726 Views | Created by g0ld2k - Thursday, April 23, 2009 3:09 PM | Last reply by Jivko Dobrev - MSFT - Friday, April 24, 2009 5:38 PM -
0 Votes
64 bit VFP OLEDB Provider
There is no 64bit MS driver for Foxpro, both the latest ODBC driver and OLEDB provider are 32bit - there never were 64bit foxpro drivers, though they are for the external world and ...Answered | 1 Replies | 5370 Views | Created by Naga Suresh AIMS360 - Monday, May 23, 2016 5:26 PM | Last reply by Olaf Doschke - Monday, May 23, 2016 6:45 PM -
2 Votes
Function to Import Excel Data to dataset in C#
Hello, For import excel data in C# you may use a 3rd party component.Answered | 17 Replies | 82027 Views | Created by Javed Ahmed - Sunday, July 22, 2012 5:42 AM | Last reply by Tim Grey - Sunday, February 17, 2019 2:18 AM -
0 Votes
Read data from Excel as text using C#
I have been using OleDb connection, so it would be really helpful if I can continue doing it with OleDb connection settingsAnswered | 3 Replies | 2899 Views | Created by Nirmal Giri A - Monday, December 17, 2012 10:22 AM | Last reply by Sergio Russo - Monday, December 17, 2012 12:00 PM -
0 Votes
OLEDB to EXCEL DATA IMPORT Using Loop
Hi Abhishek, You probably did not create an excel file before referencing it in data flow task.Answered | 5 Replies | 1387 Views | Created by ABHISHEK PARIHAR - Thursday, October 10, 2013 11:00 AM | Last reply by Dean Savović - Thursday, October 10, 2013 1:50 PM -
0 Votes
export data from xlsx into dataset in vb.net
Below is a simple example that uses the ACE OLEDB Provider.Answered | 3 Replies | 7095 Views | Created by Priya Sundaram - Thursday, April 11, 2013 11:10 AM | Last reply by Spooky201 - Thursday, April 11, 2013 3:51 PM -
1 Votes
Connecting to Excel File using OLEDB
https://www.microsoft.com/en-us/download/details.aspx?Answered | 2 Replies | 2267 Views | Created by Kevin Higuchi - Wednesday, April 5, 2017 6:20 PM | Last reply by Mike J Day - Monday, March 18, 2019 6:00 PM - Items 1 to 20 of 3888888 Next ›
No announcements
