I have data in Excel files that I am pulling out using the MS Jet OLEDB provider. The results of my select are being passed into a component that I cannot change to generate an html table on the fly. Some of my data files contain numbers that I need formatted with commas (#,###). As I said I cannot change the output component to forma...
I am getting this error when trying to connect to sybase database using oledb connectivity from visual studio.net 2005 The 'Sybase ASE OLE DB Provider' provider is not registered on the local machine. ...
Is there an OLEDB provider for WMI/WBEM? In other words, could someone access WMI through: ADO in shell vbscript ADO in ASP script ADO in Win32 native process SQL Server linked server SQL Server OPENROWSET() Is there an OLEDB provider for WMI/WBEM? Is it possible to access WMI through ADO? i hear rumors that an ODBC driver exist...
I'm sure this must have been asked before, but I can't find it. Can I set a relative path for the location of a linked table in Access 2003? The other table is also stored in an mdb file. These databases will sometimes be connected to via odbc or oledb, so relying on vba code that fires when Access opens the file will not work. If poss...
I'm attempting to take Excel 2003 and connect it to SQL Server 2000 to run a few dynamicly generated SQL Queries which ultimately filling certain cells. I'm attempting to do this via VBA via ADO (I've tried 2.8 to 2.0) but I'm getting an error while setting the ActiveConnection variable which is inside the ADODB.Connection object. I ne...
Howdy, I have a Microsoft Excel 2003 file that I am querying from C# 2.0 using an OleDbConnection. One of the cells in the Excel file is formated as a short date and displays in Excel as "1/1/2009". If I change the format to General the text displayed in that cell changes to "39814". If I query the Excel file while the file is op...
I have a csv file from which I have to populate different tables in database I am using Microsoft.Jet.OleDb.4.0 to convert csv file to data table from where I proceed forward the problem is when I do this a value such as "0261" is stored as 261, the leading zero is dropped, is there a way to prevent it??? Thanks in advance... ...
We have an application that creates a number of Visual Foxpro (DBF) tables. Each of those tables have a different schema, but they all contain a known date field. I've been asked to create another application (in C#) that will copy the last week's worth of data from each table to a new table (in a different folder to the source tables)....
Silly question, perhaps. I've developed an app on my machine that uses a Microsoft Access database (.mdb) to access certain information and populate a table with monitoring data using OLEDb. The application works fine on my machine, but when I put the release on test machines (without MS Access), it crashes. Interestingly, if I were to...
Im trying to load a csv file into a datatable using oledb. This is no problem but unfortunately one of the fields which looks numeric has a string value in about 3% of the fields and so is not being populated. because im converting the csv into xml i really don't care about inferring datatypes and simply need the data in a string as i ...
I need to create a program that can read from/write to an Excel file. Should I use OleDB or use an Excel Object? What are the advantages of one over another, and where can I read up to get started on implementing this? ...
I know this might be a bit awkward but I am trying to modify the order of certain columns in a MS Access database in C# with OLE DB. How can I commit a certain change in the order of the columns of a datatable in a dataset? If that is not possible, how can I reorder columns of database table by using a dataset? Here is a sample of what ...
hi, can anyone please help me with this query. I have a CSV file which is used by a unix application as a config file. The file has no header and the first column is unique. This is the format of the file. XXX1,11112009,11112009 XXX2,11112009,11112009 How do i, using C#: 1) update a a whole line 2) Delete a line I tried using...
I'm currently trying to access an excel 2007 file on a server that doesn't contain Microsoft Office on it. My connectionstring is something like this. String connString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + file_path + ";Extended Properties=Excel 8.0;"; But this is for 2003 format, which works fine. I would li...
Hello, I have a database (MDB, Access) and I connect it to my program using an OLE object, now I have in the db a column filled with dates (ddmmyy), I want to search and view (in Data grid view) all the fields that has a date before a Specific Date that I define . the code of search that I used is : SQLstr = "SELECT * FROM tb WHERE...
Can someone help me with this error? When I try to open a connection to an mdb, I get "The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine" error. How can I correct this? My code is pretty simple: class ImportTDB { private string filename; private string connectionString; private int collisions = ...
Hello ,,, I have an data base (.mdb) and it has a column with dates (dd/mm/yy) , some one give me a code to get all the dates in database between 2 dates , the code was : Select * from table where date between 'StartDate' and 'EndDate' but after I use the code , an error occurs told me that the types of data is not the same System...
how can use case when statement with oledb to excel file using vb.net 2.0 like select prodid, case prodid when 1 then 'fine' when 2 then 'good' end ...
I am processing an uploaded file through a ASP.NET page. I am using the following connection string: string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + excelFile + @";Extended Properties=""Excel 8.0;HDR=YES;"""; Here is the SQL statement: string sql = "SELECT * FROM [Sheet1$] WHERE [req_tf_order_no] <> ...
With the following code below I have managed to open an Access.mpd database and read rows from the table Saved. However when I try to change data or add new rows I works fine as long as the program is running but nothing seem to be saved to the access.mdb file. Update: OleDbCommand apparently cannot simply be modified inside the DataAd...