Access VBA: Convert Access tables to arff format

5 Comments

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

My experiments with sparklines

Access to the VB project is not trusted

Student’s t-test for equal means

Convert Text to Uppercase

Excel Books

About the Author

A co-author of Data Science for Fundraising, an award winning keynote speaker, Ashutosh R. Nandeshwar is one of the few analytics professionals in the higher education industry who has developed analytical solutions for all stages of the student life cycle (from recruitment to giving). He enjoys speaking about the power of data, as well as ranting about data professionals who chase after “interesting” things. He earned his PhD/MS from West Virginia University and his BEng from Nagpur University, all in industrial engineering. Currently, he is leading the data science, reporting, and prospect development efforts at the University of Southern California.

  • Wal says:
    July 19, 2009 at 8:34 pm

    Where could I download Convert2Arff.mdb? By e-mail is ok. Thank you!.

  • a7n9 says:
    July 20, 2009 at 7:17 am

    Wal,

    Sorry, while upgrading to wordpress, my files got lost. I have updated this post with the correct link. Thanks.

  • Troy says:
    October 8, 2013 at 7:36 am

    Thank you very much for this helpful tool.
    I hope you update this for the new version of MS Access and WEKA 🙂

    I have an Access database with 100,000+ rows and sample of 6 columns! Man, this worked perfectly!

  • n.ashutosh says:
    October 8, 2013 at 7:52 am

    Troy,

    Thank you for your kind note; I’m glad this helped you out. You know, I should update this post, because I’m sure there are easy ways to do this. One of these days.

  • m.es says:
    March 15, 2014 at 11:21 am

    What is the reason for this error:
    for this line: Dim rs As ADODB.Recordset
    *compile error:User-defined type not defined*

    • >