Find Jobs
Hire Freelancers

Create process to link a folder of text files to an access 2010 database programatically

$30-250 USD

Completed
Posted about 9 years ago

$30-250 USD

Paid on delivery
I am building an access database to audit my AD group environment. I have already created the process of exporting the data from AD and creating individual files with the groups and rights I need. All the files have the exact same format. A single column text file with header in first row and " text delimiter. The one column has the AD user names of the group members like "JSmith". This process would need to be a standalone application that I can designate the folder of input text files to link to,all with txt extension, the destination database and destination master table. Then 1. Link to all text files in a the source folder and create tables from the links [login to view URL] a new column in a master table with the new text files/tables name. [login to view URL] the linked file based on user name and place an "X" in a matching column IE, text file name would be " All Email Users", linked table name would be "All Email Users" and master table column name would be "All Email users", query would place an "X" in that column when, for instance "JSmith" were in the "All Email Users Group" Thank you in advance for looking at my project. This will save me tons of time
Project ID: 7111677

About the project

14 proposals
Remote project
Active 9 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
Awarded to:
User Avatar
Hi, I’m new to the Freelancer community and am just beginning to build my online reputation and client base. Over the past 17 years, I’ve worked in a variety of functions spanning Information Technology, Supply Chain, Finance and Process Optimization with a key point of connectivity being my use of MS Access/Visual Basic to solve many of the problems presented in each role. I’ve built numerous applications varying from simple reporting tools to more complex multi-user client-server applications used in production environments. I am very motivated to exceed your expectations, earn a great review from you to post on the website, and begin a long standing business relationship. Your projects sounds interesting and I've built a number of applications employing the same type of functionality; this should be a straight forward exercise that I can complete quickly for you. After that, depending on what you're looking for, we can collaborate to continue to optimize your database. Please take a look at my resume information and feel free to reach out to me if you are interested in proceeding. If you choose to hire me, I promise you won’t be disappointed. Thanks for your consideration, Rob
$155 USD in 3 days
5.0 (6 reviews)
4.2
4.2
14 freelancers are bidding on average $172 USD for this job
User Avatar
Dear, I am Access/VBA expert since 11 years. I checked your project description, and I confirm I can develop your Access DB. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
$188 USD in 3 days
4.7 (82 reviews)
7.3
7.3
User Avatar
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. We can discuss the budget post discussing the complete requirements. Lets discuss more online on chat. Thanks, Abhinav
$252 USD in 3 days
4.9 (95 reviews)
6.0
6.0
User Avatar
Hello! Thank you for taking your time to read my proposal. I have been in this industry for 6 years and such jobs are my daily practice. I can assure you that if you work with me once, you will always work with me for these kind of projects. I have been read your Project description throughout. I have been made this type of work many times. See some screenshots of my previous work in my PORTFOLIO. Let's discuss for even more details before you award me the project. Thank you in anticipation. Have a nice day...
$155 USD in 3 days
4.9 (70 reviews)
6.0
6.0
User Avatar
Hi, I have gone through your descriptions, I am 8+ years experienced Visual Basic,HTML,CSS,VB.NET,ASP.NET,MVC,C#,Bootsrap,Telerik control,Crystal report,MS Access,MySQL,SQL,MSSQL Server(2005 to On wards) developer at CMMI-5 level company.I can do your work confidently. I am very much Interested to do your work,Please revert me if you have any concern..
$252 USD in 7 days
4.0 (26 reviews)
4.9
4.9
User Avatar
I would need a few example files. I am assuming the linking to the text files is irrelevant as long as you have updated data after running the app? I would propose creating a 2 column table: column1=Group, column2=User, and importing all the text files. Then you can run a crosstab or pivot to view your data in the "Master Table" format you suggested. This 2 column table format then gives you the ability to view your data in un-thought-of ways in the future. Updating would be a simple rinse and repeat. You can then link to the 2 column table from any other database to perform other functions. I have been programming in Access/VBA for over 15 years. I speak Texas English. Contact me.
$200 USD in 2 days
4.8 (5 reviews)
3.3
3.3
User Avatar
Hello, I can develop your application. I'm a Freelance With 10 Years of Experience In Developing Applications On Ms Access For Small, Medium And Large Companies For Public And Private Sector
$150 USD in 3 days
5.0 (1 review)
2.3
2.3
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$111 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Hiring Manager I have related sort of expertise and can deliver the best. Will ensure the highest standard to satisfy you. Lets discuss pls. I will ensure the best
$200 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
The description you gave sounds reasonably straightforward as far as it goes, but I would probably need to clarify a couple of points.
$230 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have built several databases with very complex functionality. I have also linked/imported text files, so I am suited to work on this project
$144 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
5.0
1
Payment method verified
Member since Oct 3, 2004

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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.