Find Jobs
Hire Freelancers

Microsoft Access Automation

$15-25 USD / hour

Closed
Posted over 6 years ago

$15-25 USD / hour

I have a tab delimited file in a folder. I'd like to automate the process below: 1) Microsoft Access picks up the file from the folder 2) Places a predefined pivot table on the file 3) Email's the file to a predefined list outlook recipients
Project ID: 15325323

About the project

20 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
20 freelancers are bidding on average $25 USD/hour for this job
User Avatar
I have got 12 + years of experience and 500 + in Microsoft Access development behind me. I also know the automation from access. So, the program will do the following 1) It will pick up the file from the folder 2) It will Place a predefined pivot table on the file 3) It will Email the file to a predefined list outlook recipients
$16 USD in 40 days
5.0 (477 reviews)
7.2
7.2
User Avatar
Please send me a sample file and the structure of the table to which it is to be imported. In addition to importing one file we can also do this to multiple files in a folder Look forward to hearing from you Rajiv
$111 USD in 5 days
4.9 (150 reviews)
6.8
6.8
User Avatar
Hi! Can you explain steps 2? Pivot table is in what file and will be placed where? What program will create pivot table? If Access database, how? Thanks! Regards, Branislav Mihaljev
$22 USD in 40 days
5.0 (196 reviews)
6.8
6.8
User Avatar
Hi there. My name is Paris and judging from your project's scope what would be the best option for you is a macro-enabled Excel spreadsheet. By clicking a single button inside the spreadsheet the delimited file will be inserted into a sheet and the required pivot table will be created. Finally, the pivot table will be sent to a recipients list located in another sheet. All the above-mentioned functions will be implemented by clicking the button without the user to have to do anything else.
$20 USD in 40 days
4.8 (80 reviews)
6.4
6.4
User Avatar
Dear Client, According to your description. I would like to propose to build it on MS-Access 2016. User can select the folder for import and it imports the CSV file and generates the pivot report and export as PDF and send/compose to predefined email address. Please share sample of CSV file and Pivot Table Report. Thank you. Regards, Shiv
$25 USD in 30 days
5.0 (7 reviews)
5.4
5.4
User Avatar
Hi, I hope all's well with you. I see you're looking for a developer proficient in Ms Access. Really all my projects here I've developed for Ms Access/Excel/VB projects. I can build very friendly Ms Access GUI providing all 1-3 automations for your current project. ... here you can read my introduction: I’m a ms Access/VBA programmer, a mathematician and a full time developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, Ms Word, VBA, ADO, SQL including projects for start-up companies and small businesses. For over the last 25 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$15 USD in 40 days
4.6 (37 reviews)
6.0
6.0
User Avatar
Hey, I'm a professional databases and information systems developer. I have read you project description and I would like to help you get this done. I have long experience with automation and outlook integration in Access. I have strong background with Ms Access 2007 - 2016 and VBA. Check my profile for similar previous work. Looking forward to hearing from you. Regards, Alaeddin
$22 USD in 20 days
4.9 (38 reviews)
5.1
5.1
User Avatar
Hi, I'm an Access programmer for over 20 years. I can create your macro in probably less than 8 hours. I will need more information about the pivot table you want to create and the data structure. It wont be a problem to send email using outlook I did it recently using Vb .Net. So feel free to contact me to discuss your project. Regards, André
$20 USD in 20 days
4.6 (2 reviews)
5.1
5.1
User Avatar
Hello I am working with MS-Excel, Ms-Access database and VBA for the past 15 years. I have also developed many important application using MS-Access as both front-end and back-end tool. I would do your work at this competitive rate. Give me the job. Get it done, satisfy yourself and then make payment. I wont seek any payment from u until ur job is fully done as per your satisfaction. Customer satisfaction is much more important and my top most priority. No satisfaction no payment. Hope to hear positively from u. Regards John
$16 USD in 5 days
4.8 (28 reviews)
4.6
4.6
User Avatar
Hello, I have solid experience in Ms Access also i can develop this app as stand alone application (exe) using .Net framework thanks
$22 USD in 40 days
5.0 (5 reviews)
4.4
4.4
User Avatar
Hi, Greetings. I am confident about process 1 and 3. need some more information on process 2. This will be total of 20-30 hours of job. Please let me know if you are interested. Thank you.
$22 USD in 40 days
5.0 (8 reviews)
3.7
3.7
User Avatar
Hello I am a certified Microsoft Access application expert with over 14 years experience designing and developing application in Access and Excel, fully proficient with Visual Basic for Applications (VBA). For your project I would use VBA to manipulate the file (is this an Excel file?) and create the Outlook messages to send the file to your users. I have done similar projects in the past. I'm currently available full time and reside on the west coast of the United States. I could have an initial working version to you in a day or two.
$27 USD in 8 days
5.0 (4 reviews)
3.5
3.5
User Avatar
Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now
$20 USD in 20 days
5.0 (3 reviews)
1.9
1.9
User Avatar
*** I can setup the automation with access to outlook. let's discuss if interested. satisfaction assurance.
$19 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$18 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$16 USD in 25 days
5.0 (1 review)
0.0
0.0
User Avatar
Hello there! I hope you're doing well. I'm Bob and am ready to start work on your project. I'm a .NET developer with 15+ years of programming experience. I've worked on both desktop and web development projects, using both major .NET languages - C# and VB.NET. My recent experience is with ASP.NET MVC & WebAPI, MS SQL server [DML, DDL, SP], Entity Framework, nHibernate, jQuery, KnockoutJS, Twitter Bootstrap, Metro UI. I'm attaching some samples of my previous work. In September 2014 I took the Microsoft Exam 70-486 and got certified for a development of ASP.NET MVC Web Applications. I've attached a copy of the certification transcript too. I've done many projects involving importing data from various sources in various formats, including CSV. This is a trivial task and the more important is what will happen with the data afterwards. Also, you didn't mention where you'd like to store the imported data. Is there an access table involved? If no, maybe MS Access is not the right tool to use, but MS Excel. These, and probably other questions will arise, once we get in touch. So don't hesitate to contact me to discuss further and get the job done!
$25 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello I have gone through your project description.I am highly expert and well experinecd in it and can do it very well. i Have 10 years of experience and have completed 500+ projects in this domain. My expert skills are programming, Microsoft access,software development we can discuss more about this project in chat. Thanks
$15 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Brooklyn, United States
4.8
1
Payment method verified
Member since Dec 29, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.