Find Jobs
Hire Freelancers

VBA / Access / CSV professional wanted to create tool

€8-30 EUR

Cerrado
Publicado hace más de 5 años

€8-30 EUR

Pagado a la entrega
Here are a few details: We are an online trade and handle all business processes through a merchandise management system. I regularly pull the statistics as a CSV file from the system. This includes the following files: - Current stock (CSV) -Sales of the last 14 days (CSV) -Article Database (EXCEL) The first two CSV files I read about the query function in Excel. I then made a little "program", if you want to call it that, tinkered. I also worked a bit with VBA. However, the tool is very limited. The queried files must always have the same file path and must not be named differently. The files must not deviate from the internal structure, that is lines and columns must always have the same format. I use the tool to get the requisite order quantity for our various stock items, of which we have many. I then pass on this list to our supplier. Why am I doing this? Of course you can also carry out orders on minimum stocks, which can be set in WaWi. But because of our large number of different items, I also need to know how much I have to reorder from each item. This is not calculated by our WaWi. The whole thing should now look a little more professional and above all be universally applicable. I would like to Select files from any location on your hard disk and let them analyze. Also our article database is currently an Excel file. It now leads over 1000 lines and for such Excel is well known not designed. Access would then come into play here. Later, I would also like to have the income statement, etc. create over the program. It would be nice if you can integrate that later or maybe already. If necessary, I can send everything I can the "program" also like in its components. It would be best, but once everything to discuss locally, so I can show how I currently rule everything. But this would also be possible via Skype / Teamviewer. But it would be nice if I knew beforehand how much the effort will be and what price you can imagine. I am looking forward to your reply.
ID del proyecto: 17535005

Información sobre el proyecto

16 propuestas
Proyecto remoto
Activo hace 6 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
16 freelancers están ofertando un promedio de €75 EUR por este trabajo
Avatar del usuario
Hello, I have the good knowledge of VBA / Access / CSV professional wanted to create tool. I have more than 5 years of experience in Excel, Microsoft Access, Software Architecture, Visual Basic, Visual Basic for Apps. I have reviewed your job and can deliver you the job with 100% satisfaction. Please ping me for more discussion.
€160 EUR en 2 días
4,9 (620 comentarios)
8,6
8,6
Avatar del usuario
Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your MS-Access program. Please give me more details about your project. 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
€19 EUR en 3 días
4,8 (99 comentarios)
7,4
7,4
Avatar del usuario
I have read your description. I believe I can assist in your project. My passion is building Custom Access ands Excel Databases. I have built well over 300 custom databases in the past 19 years. I have taken all classes from beginner to expert 97 to 2013 in access and excel. I can send working samples on request. Some of the databases I have built include Production, Inventory, Scheduling, time-clock, Book-Keeping, facilities management, and many custom databases I am bidding on your project because I feel my experience and education has prepared me well for it. My strong desire to become one of the best in my field is my motivation to excel as an Access Developer and I would appreciate the opportunity to put my skills and experience to work for you. What you get if you allow me to do your project. The Database to your vision. I will create the database and continue to change upon your input until it is what you in vision. I will offer lifetime support for the database; I will give all my contact information if chosen to complete your Project. I if there are any bugs or issues to the original Database I will fix free of charge. Thank you for your time.
€34 EUR en 40 días
4,8 (44 comentarios)
6,7
6,7
Avatar del usuario
Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Access. Really all my projects here I've developed for Ms Access/Excel/VB projects. I'll do your current project via Ms Access for $750 USD during 2 weeks - very professionally and on time- only during coding I'll need each day communication with you. Here is my introduction: I’m a ms Access/Excel/VB 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, VBA, ADO, SQL , including projects for start-up companies and small businesses. For over the last 20 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
€23 EUR en 1 día
4,8 (86 comentarios)
6,6
6,6
Avatar del usuario
I have excellent command on MS Excel and MS Access VBA. I have completed complex projects in both before . For instance - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs - Built a POS and inventory management system - Built a hotel price comparison that pulls data using the website's API You can see the reviews of the same in my profile Thanks, Archana
€80 EUR en 2 días
4,9 (104 comentarios)
6,2
6,2
Avatar del usuario
Hi, I'm a professional Ms Access and VBA developer with strong background in developing and implementing information systems with databases from scratch. I have read your project description and I'll be glad to assist you with whatever you need. I'd like more details so that I can give you my final timeframe and quote. I have done similar assignments previously, so check my profile for details. I'm looking forward to hearing from you. Regards,
€34 EUR en 1 día
4,9 (72 comentarios)
5,9
5,9
Avatar del usuario
- Based on the two CSV files CUrrent Stock, Sales for the last 14 days and the logic that needs to identify the the stock that needs to be reordered from the respective supplier can be generated. - Solution could be built on Excel or MS Access based on the complete understanding. - Have done very complex solutions in Excel and also in MS Access - Am not sure how WaWi works but we can have a threshold value set, for each item or make it generic so that at any point of time if the stock reaches the reorder level then we can list all those itmes for the day. - Have it segreggated to be sent to respective supplier. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables
€160 EUR en 4 días
4,6 (54 comentarios)
6,1
6,1
Avatar del usuario
Hi, I've been in excel vba macro for 3 years and currently creating company tools for users reporting. Willing to help you with your project, just let me know and we can discuss it further. Thanks, Marlou
€34 EUR en 5 días
2,9 (8 comentarios)
4,3
4,3
Avatar del usuario
Hello, I'm VB expert, I think you will be satisfied, we can discuss eveything via Skype for free of course.
€29 EUR en 1 día
5,0 (1 comentario)
2,4
2,4
Avatar del usuario
Hi Sir I'm a new freelancer. As such I can do the task at minimal cost or even for free as I'm looking only for positive feedback. Please let me know your requirements Regards,
€8 EUR en 1 día
5,0 (8 comentarios)
2,0
2,0

Sobre este cliente

Bandera de GERMANY
Söhrewald, Germany
5,0
14
Forma de pago verificada
Miembro desde dic 9, 2017

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.