Recently, I had the need of printing the data structures of many dbf files. A google search reveled the DBF.COM file that would output dbf file structures, number of records, file name, date of last update, etc. Download this file here: files/DBF.COM (Caution: I downloaded this file from the internet, and I do not make […]
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 readingIf you want to delete all or some of the tables from your Access database, you can use this DAO approach. You would need a reference to Microsoft DAO 3.x object library. As shown in the example, you can use an array to store the table names, which you want to keep or delete. Sub […]
Continue readingIf you would like to link all Dbase files, any linkable file for that matter, in MS Access, use the following code. I read somewhere that refreshing the links is slower than deleting and creating new links. Sub LinkAllTblsinDir() Dim sTblNm As String, sPath As String, sFileNm As String sPath = “C:\DW\” ‘Turn of the […]
Continue reading