Closed

VBA / Access / CSV professional wanted to create tool

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.

Beceriler: Excel, Microsoft Access, Yazılım Mimarisi, Visual Basic, Uygulamalar için Visual Basic

Daha fazlasını gör: create vba access 2007, create report template via vba access database, script vba importar csv access, importing text file into access using vba, ms access vba link text file, access vba import csv into existing table, access export to csv vba, access vba import text file into existing table, vba read csv file, ms access import csv to existing table, ms access vba import csv to existing table, sql, excel, create form vba access 2007, excel vba insert csv data access database, access csv vba, create access csv, vba import csv access vba, vba import csv access, vba import csv access 2003

İşveren Hakkında:
( 8 değerlendirme ) Söhrewald, Germany

Proje NO: #17535005

Bu iş için 18 freelancer ortalamada €69 teklif veriyor

schoudhary1553

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

in %bids___i_period_sub_35% gün içinde160%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(269 Değerlendirme)
7.5
fabest

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

in %bids___i_period_sub_35% gün içinde19%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(94 Değerlendirme)
7.4
workerbee1974

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

in %bids___i_period_sub_35% gün içinde34%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(34 Değerlendirme)
6.3
satishtl

- 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

in %bids___i_period_sub_35% gün içinde160%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(48 Değerlendirme)
5.9
ferozstk

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(42 Değerlendirme)
5.8
abhinovpankaj

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

in %bids___i_period_sub_35% gün içinde39%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(66 Değerlendirme)
5.6
alaeddindhahri

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(63 Değerlendirme)
5.6
archanaoswal

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

in %bids___i_period_sub_35% gün içinde80%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(67 Değerlendirme)
5.7
zu02

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(54 Değerlendirme)
6.2
mexmarius

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

in %bids___i_period_sub_35% gün içinde388%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(22 Değerlendirme)
4.6
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(8 Değerlendirme)
4.1
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(10 Değerlendirme)
3.6
in %bids___i_period_sub_35% gün içinde24%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(10 Değerlendirme)
3.7
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(4 Değerlendirme)
2.5
marloufin

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

in %bids___i_period_sub_35% gün içinde34%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)
4.2
FirestarterXIII

Hello, I'm VB expert, I think you will be satisfied, we can discuss eveything via Skype for free of course.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(1 Yorum)
2.4
stanleyw12

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,

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(5 Değerlendirme)
1.7
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(0 Değerlendirme)
0.0