Create Sevearl MS Access Queries from Excell Workbook

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.

Taidot: tietojenkäsittely

Näytä lisää: microsoft access job, job ms access, find a postal code, excell job, ms access job, queries, ms access 2013, create balance, access clean data, create workbook, create code access, moth, access commission, excell files, workbook access, microsoft access assignments, xls clean, postal address xls, create postal address, code microsoft access, find job commission, rep commission, address postal code, data clean access, microsoft access code

Tietoa työnantajasta:
( 40 arvostelua ) Waynesville, United States

Projektin tunnus: #4276730

Myönnetty käyttäjälle:


Hello Sir, MS Access Excel and VBA expert here, I m ready to start plz chk pm for DEMO.

$55 USD 2 päivässä
(4 Arvostelua)