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.
Bu iş için 18 freelancer ortalamada €69 teklif veriyor
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 App Daha Fazla
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 Daha Fazla
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 cl Daha Fazla
- 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 b Daha Fazla
Hello, After reading your project details I believe I'm suitable for this project. As I'm expert on this kind of project with more than 5 years [login to view URL] feel free to contact me.I am looking forward to hear Daha Fazla
Hello, I have been working as freelancer since last ~ 6 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat Daha Fazla
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 Daha Fazla
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 (A Daha Fazla
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 v Daha Fazla
Hi there, My name is Marius, a UK based developer/analyst, and I bring in over 8 years of VBA development at agency level standards. With a strong background as VBA developer and MI data analyst, with projects comple Daha Fazla
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
Hello, I'm VB expert, I think you will be satisfied, we can discuss eveything via Skype for free of course.
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,