Find Jobs
Hire Freelancers

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

$30-250 USD

Завершено
Опублікований over 9 years ago

$30-250 USD

Оплачується при отриманні
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
ID проекту: 7111677

Про проект

14 пропозицій(-ї)
Дистанційний проект
Активність 9 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
Доручений:
Аватарка користувача
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 за 3 дні(-в)
5,0 (6 відгуки(-ів))
4,2
4,2
14 фрілансерів(-и) готові виконати цю роботу у середньому за $172 USD
Аватарка користувача
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 за 3 дні(-в)
4,7 (82 відгуки(-ів))
7,3
7,3
Аватарка користувача
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 за 3 дні(-в)
4,9 (95 відгуки(-ів))
6,0
6,0
Аватарка користувача
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 за 3 дні(-в)
4,9 (70 відгуки(-ів))
6,0
6,0
Аватарка користувача
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 за 7 дні(-в)
4,0 (26 відгуки(-ів))
4,9
4,9
Аватарка користувача
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 за 2 дні(-в)
4,8 (5 відгуки(-ів))
3,3
3,3
Аватарка користувача
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 за 3 дні(-в)
5,0 (1 відгук)
2,3
2,3
Аватарка користувача
A proposal has not yet been provided
$155 USD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
A proposal has not yet been provided
$111 USD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 за 5 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 за 5 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор UNITED STATES
United States
5,0
1
Спосіб оплати верифіковано
На сайті з жовт. 3, 2004

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.