Approx 300 individual MS Excel CSV files which need to be imported into an Access database. I will be adding more files daily, but they will all have the same format and the file names are xxxxx01012017 with the last of the names being the dates.
I would like to automate this process.
To prove you have read this "project" description and understand the requirements, please include the word "Preds" as the first word in your response.
This process needs to be able to change as I will be using this workflow for establishing future ETL into new databases with new data, same format, but different inside content.
I look forward to discussing this project more soon.
Preds
I have great skills for excel and access. I will create linked accesses database which will auto update as you upload the data in a specific file, please
Preds
Hello, dear sir!
I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the minimum price and in the shortest possible time and with the highest quality!
From the Access, of course, familiar.
Give me a chance to show what I can do!
Preds
Hello, sir
I saw your project and analyze your requirements.
I like such kind of tasks and I know how to code this as I already dealt with similar problems in my career before.
I am senior Access/SQL/VB /Excel developer since 1997 and I can write for you a user-friendly program using MS Access/Excel .
I am not engaged with any other project right now and I will work for 8 hours day for this Job. You can look into my portfolio here for my software screens for my previous work.
Do revert me back if you feel like I am a suitable candidate for this Job and discuss further details.
Thank You and Regards,
Zura
Preds,
Hi,
I'm a senior databases developer. I have solid background developing databases from scratch using MsAccess. I also have good experience with automation for Data Import from Excel,CSV,TEXT files. I have the script already developed and I can tweak it to accommodate your needs.
Check my profile for similar previous work.
PS: You have added Excel in your project skills, so the top bidders are data entry agents not Access developers.
Best,
Alaeddin
Preds
I am an Australian Technical Business Analyst with 15 years experience building complex automated and reporting solutions using Access, VBA, SQL Server, and Excel.
A couple of questions:
1. Would you want to be able to specify the location of the files somewhere within the Access DB (which I think would be best so if the location ever changes you can update this yourself without having to touch code)
2. I'm assuming you would then want each file moved to an archive location? Again would you want this specified within the DB?
Preds
I have read all the details and below would be my steps
1. browse option to select the forder of csv files.
2. click on and it will run a loop and import all data from available csv files of selected folder.
I am a full time MS Access developer. let me know if you wish to proceed.
Good Day,
I will be able to do this project, directly in Excel, with no Macros.
The solution will be fast, scalable, robust and easy for you to use - all you need to do is add more CSV files to the folder, press refresh and you will get the new data.
Awesome,
Wez
Preds
Hello,
I have been working as an IT BI DWH Professional since last ~ 7 years, as an.
The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in nourishing my talent in all the technologies around these 3 layers.
Below are some key areas of my skills:
• Expert in SQL Server, Oracle ,MySql and MS Access Databases
• Expert in BO XI, Cognos and SQL Server Reporting Service (SSRS)
• Expert in & designing & Implementation of end to end ETL Process using Informatica & SSIS Tools
• Expert in Designing Qlikview Dashboard BI Solution
• Expert in ER & Dimension Data modeling
• Complete Command on PL/SQL concept e.g. Procedures, Functions, packages and complex queries.
• Basic knowledge of Unix Shell scripting
• Web Development using Java, CSS, and HTML, PHP & Java Script
• Expert in excel Macro
• Expert in C & C ++ Programming
I have experience in all the above areas which I have gained during execution of project work.
As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best.
I had conducted Informatica & DWH training for a US based training organization from Nov’14 to Dec’14.
We recently started our own company “Point5Nyble Your Needs, Our Dream”.
We always work to provide Best Delivery with 100 % customer satisfaction.
Would be looking forward to work on this opportunity and will ensure to deliver best.
Regards,
Point5Nyble
Preds . do you want me to make it in ETL process in ssis , I would like to do this and need more inputs for automation . I am experitse in automation and ETL from different data sources . please let me know for any questions
Preds
More than 7 years of IT experience in data analysis, data architecture, application design, dimensional data modeling, implementation and testing of Enterprise Data Warehousing and Enterprise Database, Data Mining.
Preds. Hi, I've been working full-time for 10 years building ETL processes. I shouldn't have any problems with this project and would love to talk through the specifics with you further! Thanks!
Relevant Skills and Experience
I mostly work in C# these days and use Azure extensively if that interests you. I have quite a bit of ETL experience in general from many sources to many targets, CSV to Access included.
I have write so many process for ETL and I have very good experience in that
I have write so many process for ETL and I have very good experience in that