I have a few Microsoft XLS document that I need imported into Microsoft Access. The XLS has junk data for an Address, Postal Code, Telephone Number, Balance, Amount Paid, Ad Rep Number, Last Name, First Name, Address, City, Ad Rep Postal Code, Commission Rate, and Commission YTD.
Once imported into Microsoft Access I need a few basic queries to be run as well as some clean up. The job completed should have 2 Access files.
The first will be a few queries using the data from the XLS to find specific entries based on Location, amounts, and adding totals or balances.
The second would be to import the same XLS and sort the Access DB, change record entries data as specified, etc.
Both files are quite basic and related to a Basic Computer Course's assignments. If Possible, I would like them sometime early next moth.