I need to write an application to call a database file, which I can the user can then use to sort and search data. The database is located online and will be updated by a third party regularly. It is a .csv file, which should be viewable in Excel. I have some very basic programming experience from college but am largely unfamiliar with the current APIs and other tools that are available. I need to know in basic Java how to retrieve the data through an application. I am learning SQL and feel that I should be able to use that without any problem. However, I am kind of lost in forming the framework for my application. I have been using Netbeans and attempting to figure out how to accomplish my task using Derby, but without any success. Any help would be greatly appreciated! Thanks in advance.
email: matt171980@hotmail.com