We had this annoying problem: a simple query in Access to a linked table (using ODBC and MS SQL server) returned incorrect results, though the same query returned correct results in MS SQL server. By incorrect I mean the field values were different, so rather than returning AZ, the query returned BZ (some other value […]
Continue readingWell, I got this error message today while I was trying to import a text file: “The search key was not found in any record” After some research, I found that either it was a bug caused by Microsoft Jet 4.0 Service Pack or it was the size of the database (should be not greater […]
Continue readingProblem: When I tried to export a table/query from Access 2007 to Excel 2007, I was getting this annoying error: You selected more records than can be copied onto the Clipboard at one time. Divide the records into two or more groups, and then copy and paste one group at a time. The maximum number […]
Continue readingWeka, an open source data mining software, uses arff input data format. You can use this code to convert any Access table to arff format. Download the Access database with code: Convert2Arff.mdb This can very well be designed using forms, but this should get one started. Use Alt + F11 to see the code, then […]
Continue readingIf you want to export Access tables using ODBC/DSN connections, use the following code. This procedure uses the File DSN and ODBC connection to export Access tables using DAO object TableDef. Sub ExportTbls() Dim sTblNm As String Dim sTypExprt As String Dim sCnxnStr As String, vStTime As Variant Dim db As Database, tbldef As DAO.TableDef […]
Continue reading