Word frequency database

[arwer13]

Can you give me a simple example in code of populating a database using data from a csv file? I uploaded a simple word frequency database in SQLite and Access along with an Excel spreadsheet to Dropbox. These are words I complied from various lists of words that might appear on the SAT, a college-prep test that many Americans take.

[arwer13]

What other csv files did you mean? Only Sp5000.txt and Sp1000.txt are real csv.
Here is an example of a program populating db with word frequencies from Excel table. I redesigned the table a little bit 661b520
Would you like to redesign it so that the database contains information about

• language of every word,
• other frequencies of this word (there are many in the xlsx file)?

Then we could load words from SP*.txt as well to the same database.