oledb Questions
3
Solved
10
I need to access an excel spreadsheet and insert the data from the spreadsheet into a SQL Database. However the Primary Keys are mixed, most are numeric and some are alpha-numeric.
The problem I h...
Alinealinna asked 18/11, 2008 at 13:35
1
Solved
Following code takes like 2500 milliseconds on an i7-*3.4 GHz windows-7 64-bit computer to read an excel sheet with 25000 lines and 5 columns. Each cell approximately include a string with 10 chara...
Sternmost asked 3/7, 2012 at 14:5
2
Solved
I'm trying to connect to an Access database file using a System.Data.OleDb.OleDbConnection. I need to connect in readonly mode because another application uses it at the same time. I can connect to...
Purapurblind asked 9/5, 2011 at 21:52
1
Can anyone tell me OleDB Connection string to be used for just reading an Excel file exclusively opened by other user?
I tried following connection string which did not work for me:-
"Provider=Mi...
Chessboard asked 2/5, 2011 at 5:38
4
Solved
sqlQuery = "SELECT [ID] from [users] WHERE CallerName=@CallerName";
OleDbConnection conn = new OleDbConnection(connectionString);
conn.Open();
cmd = new OleDbCommand(sqlQuery, conn);
cmd.CommandTe...
Truss asked 27/4, 2012 at 16:34
1
Solved
I need to read XLSX files and extract a maximum amount of content from it. Which of the API's should I use?
OLE DB, open XML SDK, or Excel Interop?
Which is the easiest to use?
Can you retrieve...
4
Solved
Is there any way to query an excel 2010 spreadsheet, without using Jet or exporting as a CSV and querying the csv file.
The reason why I cannot use Jet is because the application needs to run as a...
2
Solved
I'm using OleDB and I want to export my objects into excel table. Each row in the sheet will be one of my objects. The problem is that I don't know how to insert data when there's no column headers...
Veinlet asked 19/4, 2012 at 7:51
1
Solved
I want to execute simple statement:
SELECT * FROM
OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Text;Database=C:\Temp\;','SELECT * FROM [test.csv]')
And suddenly I get this message today morning:
Msg ...
Geronto asked 13/3, 2012 at 16:2
3
I'm currently trying to use OleDb/JET to export SQL Server data to an Excel 2003 file. I initially coded the export in a console application, and it worked fast enough. However, running the same co...
3
Solved
At the MSDN website it says, "Connecting to SQL Azure by using OLE DB is not supported."
There are other places on the web where folks report that it works fine for them after tweaking the server ...
Fakir asked 21/6, 2010 at 15:5
3
I am writing an application on Visual Studio 2008 with C#. The application reads data from an access file and then generates a txt file. I was doing some tests with a mdb file with 1.000.000 record...
Flourishing asked 30/9, 2011 at 3:11
1
Solved
i am trying to fetch some data from an excel file, the issue was that i read the first row as data so i decided to change the HDR in my connectionString to Yes but after that my program end up with...
1
Solved
i wrote script for downloading mdb files and reading them due OLEDB provider. All works fine, but if i try to read from table, it throws an exception:
Ms Access: Record(s) cannot be read; no read ...
Seclude asked 20/2, 2012 at 12:39
3
I know questions this kind are asked from time to time but i can't find any satisfying solution.
How can I open a CSV-File using MS ACE OLEDB 12?
I try it with the following code.
DbConnection c...
Sayed asked 3/3, 2011 at 15:26
2
Solved
Does anyone have a sample code that given the database file displays the names of all the user tables there?
I am not interested in a .NET code, just the C++.
I am trying to grok OLE DB to do the...
Shortcake asked 8/1, 2012 at 19:46
3
Solved
I have changed my previous code so I am not using 'using'. It work earlier, and code in different class basically represent the same thing, but its working.
I have stared at it for 2 hours now and...
2
4
Solved
Discovered that OleDBConnection doesn't seem to be ThreadSafe. It appears that it attempts to open multiple connections instead.
//doesn't work
using (OleDbConnection oConn = TheDataAccessLayer.Ge...
Whimsey asked 9/10, 2011 at 18:41
6
I read/update data from MS Access using C#.
My code is:
public static void UpdateLastLogin(int userid, DateTime logintime) ///logintime = DateTime.Now
{
string sql = @"UPDATE [Customers] SET [Las...
4
Solved
I am trying to transfer bulk data on a constant and continuous based from a SQL Server database to a MYSQL database. I wanted to use SQL Server's SSMS's replication but this apparently is only for ...
Coward asked 15/8, 2011 at 22:1
1
Solved
I've been following this article here:
http://blogs.msdn.com/b/sqlcat/archive/2011/03/08/linked-servers-to-sql-azure.aspx
on how to setup a Linked Server from SQL Server 2008 R2 to an SQL Azure i...
Panther asked 25/8, 2011 at 14:2
3
Solved
So I have learned that that the Microsoft.Jet.OLEDB.4.0 data provider for querying data sources like Microsoft Access MDB files and Excel spreadsheets does not work under a Windows 64-bit operating...
7
Solved
Does anyone know how to write to an excel file (.xls) via OLEDB in C#? I'm doing the following:
OleDbCommand dbCmd = new OleDbCommand("CREATE TABLE [test$] (...)", connection);
dbCmd.CommandTime...
© 2022 - 2024 — McMap. All rights reserved.