Access VBA: Convert Access tables to arff format

Weka, 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 execute procedure ConvertTbl2Arff to convert a table.

Some highlights of this procedure
- Takes care of spaces in Attribute name and data values
- Finds unique values of nominal variables
- Assigns equivalent ARFF datatype
- Replaces missing values with question marks

Related posts:

1. Access VBA: Export Access tables using ODBC
2. Access VBA: Delete tables from Access database
3. Access VBA: Link all Dbase files from a folder
4. XY scatter plot in MS Access
5. Convert a number to its equivalent letter