Calculate and export from Access to Excel

Ολοκληρωμένο Αναρτήθηκε Jun 26, 2015 Πληρώθηκε κατά την παράδοση
Ολοκληρωμένο Πληρώθηκε κατά την παράδοση

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.

Excel Microsoft Access Visual Basic

Ταυτότητα Εργασίας: #7944892

Σχετικά με την εργασία

15 προτάσεις Απομακρυσμένη εργασία Ενεργό Jun 28, 2015

Ανατέθηκε στον:

BitSDestiny

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 Περισσότερα

$35 USD σε 1 μέρα
(9 Αξιολογήσεις)
3.7

15 freelancers κάνουν προσφορές κατά μέσο όρο $35 για αυτή τη δουλειά

sonarkaushik

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 Περισσότερα

$45 USD σε 3 μέρες
(41 Αξιολογήσεις)
5.5
dipakmoliya

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". Περισσότερα

$30 USD σε 1 μέρα
(35 Αξιολογήσεις)
4.9
rajafaizan

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 Περισσότερα

$63 USD σε 3 μέρες
(18 Αξιολογήσεις)
4.2
AlexandrK1

Предложение еще не подано

$44 USD σε 3 μέρες
(15 Αξιολογήσεις)
4.3
TonmoyRoy111

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 Περισσότερα

$30 USD σε 2 μέρες
(17 Αξιολογήσεις)
3.2
TOKOYASU

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 Περισσότερα

$25 USD σε 1 μέρα
(1 Κριτική)
2.8
leelaaswanth

will give you 100% accurate and efficient output.......................................................................................

$25 USD σε 1 μέρα
(10 Αξιολογήσεις)
2.9
jfayes

A proposal has not yet been provided

$22 USD σε 1 μέρα
(3 Αξιολογήσεις)
1.9
danangvw

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 Περισσότερα

$10 USD σε 1 μέρα
(4 Αξιολογήσεις)
1.7
auib786

A proposal has not yet been provided

$25 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0
Jpenuliar

5 year Data Analysis Experience. Excellent MS Access, VBA, Excel Formula, Pivots and Qlikview experience.

$25 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0
lalmansari

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 Περισσότερα

$23 USD σε 2 μέρες
(0 Αξιολογήσεις)
0.0
michaelnicolas

A proposal has not yet been provided

$88 USD σε 3 μέρες
(0 Αξιολογήσεις)
0.0
elavarasan155

A proposal has not yet been provided

$30 USD σε 3 μέρες
(0 Αξιολογήσεις)
0.0
excelfandoo

A proposal has not yet been provided

$25 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0
barkatmulani

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 Περισσότερα

$30 USD σε 3 μέρες
(0 Αξιολογήσεις)
0.0
elephentplayer

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.

$35 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0