Calculate and export from Access to Excel
$10-30 USD
Πληρώθηκε κατά την παράδοση
I need some help finalizing my project.
I have most of the ground work completed
I need someone with more experience with access and excel to finish it off.
1. To start off I receive a txt file “Attached” that I want to be able to automatically import into a MS access database by using a button.
2. If an import error is created have it deleted
3. I have a query that will remove the spaces inform of the number 7 and only pull records with the starting number is 7 (Completed)
4. Automatically have a excel spreadsheet open and have the data from the query export into four tabs “Sheets”
5. The first set of data will be the complete file from the query/new Colum showing how many days past due/high light in yellow
6. The second export will be all account with the Dis Date over 60/new Colum showing how many days past due
7. The thirst export will be all accounts that have not made a payment in over 60 days/new Colum showing how many days past due
8. The four export will be all account that are 60 days past due/new Colum showing how many days past due
Help light in yellow all payments over 60 days late
Please review what I have competed so far in case this helps you.
Ταυτότητα Εργασίας: #7944892
Σχετικά με την εργασία
Ανατέθηκε στον:
I am 8+ Years of Experienced Software Developer. ASP .Net , C# , VB .Net , Visual Basic, Excel VBA , MS SQL Server , MYSQL , Oracle , MS Access, Crystal Report, Telerik , Bootstrap , HTML 5 , CSS , Java Script are my Περισσότερα
15 freelancers κάνουν προσφορές κατά μέσο όρο $35 για αυτή τη δουλειά
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will deliver flawless work. I am very much able to work on this. ***I am ready Περισσότερα
Hi! there, My name is Dipak Moliya. I’ve read your project description and can see that you need automatically have a excel spreadsheet open and have the data from the query export into four tabs “Sheets". Περισσότερα
Hello Sir, I guarantee you 100% satisfaction. Would you like to discuss with me.....we negotiate about price and time.....My expertise lies in quality service and delivery on Time. Kindly if you want high quality work Περισσότερα
Dear Employer I can do the job for you. I have sound knowledge in excel and I have previously carried out a number of projects in excel using machros and formulas. Kindly contact me for further details. Thanks and rega Περισσότερα
I am an experienced young professional with skills in Excel, spread sheets and database management with a result oriented mindset. I believe in offering quality and customized services to my clients within the stipulat Περισσότερα
will give you 100% accurate and efficient output.......................................................................................
I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administ Περισσότερα
5 year Data Analysis Experience. Excellent MS Access, VBA, Excel Formula, Pivots and Qlikview experience.
Hi, Though I am new in freelancing industry, but I have a total experience of 4+ in IT sector. Earlier I use to write macros to ease my work and to perform daily activities efficiently. Hire me if your are inter Περισσότερα
I have over 8 years of experience working with MS Access applications. Have developed a number of database applications using MS Access VBA. Could design reports to any level of complexity. Development of fully normali Περισσότερα
Hello, Dear Friend. I am expert in Visual Basic, Excel, Access I have a lot of experiences in many fields. I can help you well. Please contact me. Best regards.