Hi All, I'm creating a utility to import data from Excel to Oracle database, I have a fixed template for the excel file, Now, when I'm trying to import the data by Jet provider and ADO.Net - Ole connection tools, I found the following problem: there're some columns haven't been imported because there are mixed data types in their colu...
This is not a problem that needs answering, more of a query on why this is happening. I have a field in one table that is populated with 'Y' Or 'N', and i have a query that simply takes the value of that field and pops into another table The table has approximately 25,000 records in it The query below takes about 25 seconds to run UP...
I'm working on an application that talks to an Access database via DAO. Normally I use CreateObject("Access.Application") to get a copy of Access, then refer to the database via Application.CurrentDb, which works fine. But for some activities we need to do this instead for speed (VBA written for clarity, though the app is actually in C...
Hi guys, First, I want to say that I'm out on deep water here, since I'm just doing some changes to code that is written by someone else in the company, using OleDbDataAdapter to "talk" to Excel and I'm not familiar with that. There is one bug there I just can't follow. I'm trying to use a OleDbDataAdapter to read in a excel file with ...
I have a legacy desktop application using JET for the database. The application needs to be able to access the database file from a network drive. Should I migrate the data access to SQL CE (or SQL Lite), or leave it in JET? Maximum table row size is around 50000. ...
Hallo all. I need to run the 'replace([column], [new], [old])' in a query executing on n Access 2003 DB. I know of all the equivalent stuff i could use in SQL, and believe me I would love to, but i don't have this option now. I'm trying to do a query where all the alpha chars are stripped out of a column ie. '(111) 111-1111' simply bec...
Hi all, I'm stuck trying to get SSIS 2008 to read an Excel file. Yesterday, I migrated our SSIS project from 2005 to 2008, and though the upgrade said it worked, I cannot get it to read an Excel file. I read online that I needed to upgrade the JET drivers to Office 2007 (AccessDatabaseEngine.exe), which I did. And voila! Everything s...
Hi, I'm supporting a customer with strange, very specific mdb access slowdowns. We have a big ( > 100MB) mdb file which is read by our app through ADO, and on some Vista machines (and only on those Vista machines), some, but not all queries take a very long time to execute. The slow query: SELECT * FROM [Table] WHERE [FieldA] = _numbe...
I have a query and I would like to use an IIf function as part of the criteria. Here is the full SQL: SELECT Hits.HitID, Hits.ListingID, Hits.HitCount, Hits.HitDate, Hits.HitTypeID, Hits.IsDeleted FROM Hits WHERE (((Hits.HitDate)>=[Forms]![frmReports]![txtStartDate]) AND ((Hits.IsDeleted)="N")); Here is the piece of code that causing...
Hi all when I use microsoft jet database engine for udpating excel work book it works correctly but when I usnng microsoft.ace.oledb 12.0 for working xlsx files I got this error : operation must use an updateable query ...