Hi guys I need some help with an idea i have. I work for a company that does monthly audits of items in a grocery chain. I have all my field reps setup to use excel files to complete their audits and then they send them to me. At the end of each week i have to look through each audit (close to 60) to tally up the total # of voids (items not carried that they should have) and then list how many total voids for each product throughout the whole chain. I am wondering if it is possible to use a c++ program to do this or if another language can possibly do this for me. I have done something like this with a txt file before but that really is not possible for this type of thing. Any ideas would be much appreciated. Thanks!!
RobBrown
29
Light Poster
Recommended Answers
Jump to PostIf you don't want to do it in Excel or as a CVS file as previously mentioned, then I'd go with VB.NET because I think it has built-in support for Excel files. But then I could be wrong because I don't know a whole lot about vb.NET.
Jump to PostHere's an example of using ADO.NET (it's using VB.NET (viz AD's post) on an ASP.NET page but just ignore the ASP.NET part). You could use it with C++/CLI but that will require picking up some new syntax. If you have the fancier versions of VS (Professional or …
All 7 Replies
jonsca
1,059
Quantitative Phrenologist
Team Colleague
Featured Poster
Andreas5
13
Junior Poster in Training
Team Colleague
Ancient Dragon
5,243
Achieved Level 70
Team Colleague
Featured Poster
jonsca
1,059
Quantitative Phrenologist
Team Colleague
Featured Poster
RobBrown
29
Light Poster
Ancient Dragon
5,243
Achieved Level 70
Team Colleague
Featured Poster
RobBrown
29
Light Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.