Forum Thread

Software to find excel Data

netsfan549 836 38 September 21, 2016 at 07:03 AM
I currently work in the inventory department. For example, when I receive a switch in, I put in excel Extreme X440-48T. If my boss wants to know if we received this item I would just go to windows search to see if we have or not.

Lately windows search has been flanky. I would put in X440-48T and nothing comes up. I want to know if there is a software for a better search mechanism for excel data? Thank you

3 Comments

1

Sign up for a Slickdeals account to remove this ad.

Joined Feb 2004
L10: Grand Master
6,951 Posts
944 Reputation
#2
Quote from netsfan549 View Post :
I currently work in the inventory department. For example, when I receive a switch in, I put in excel Extreme X440-48T. If my boss wants to know if we received this item I would just go to windows search to see if we have or not.

Lately windows search has been flanky. I would put in X440-48T and nothing comes up. I want to know if there is a software for a better search mechanism for excel data? Thank you
Is all the data in one file? Or spread out over multiple files? Are the Excel files saved as Excel workbooks (.xls or .xlsx), or a more generic format (like .csv)?
Reply Helpful Comment? 0 0
Marshall: Have the rest of you guys figured out by now that mmathis is the smartest guy on SlickDeals?
#3
There are professional programs designed for commercial inventory control. Doing this sort of thing in Excel spreadsheets is sort of asking for trouble. If you want to manage it yourself with an in house program, then at a minimum one should be using some sort of front end program which is tied to a real database server (i.e., SQL Server) on the back end imo. Doing anything substantial or business critical in an Office Product is just a prescription for disaster in a decent sized business imo.

I have seen it all go wrong in the past from HR people thinking they are IT and coding up a time reporting system for 1000s of employees using MS Access to Financial guys thinking they are IT and doing company fiscal reporting out of MS Excel. It never ends well.

http://www.toptenreviews.com/busi...-software/
Reply Helpful Comment? 0 0
Joined Jan 2011
L5: Journeyman
836 Posts
38 Reputation
Original Poster
#4
Quote from mmathis View Post :
Is all the data in one file? Or spread out over multiple files? Are the Excel files saved as Excel workbooks (.xls or .xlsx), or a more generic format (like .csv)?
Mutiple files; its sorted by dates. and I have it saved as .xlsx

Quote from YanksIn2009 View Post :
There are professional programs designed for commercial inventory control. Doing this sort of thing in Excel spreadsheets is sort of asking for trouble. If you want to manage it yourself with an in house program, then at a minimum one should be using some sort of front end program which is tied to a real database server (i.e., SQL Server) on the back end imo. Doing anything substantial or business critical in an Office Product is just a prescription for disaster in a decent sized business imo.

I have seen it all go wrong in the past from HR people thinking they are IT and coding up a time reporting system for 1000s of employees using MS Access to Financial guys thinking they are IT and doing company fiscal reporting out of MS Excel. It never ends well.

http://www.toptenreviews.com/busi...-software/ [toptenreviews.com]
Thank you sir, I will look into this
Reply Helpful Comment? 0 0
Last edited by netsfan549 September 21, 2016 at 08:02 AM
Page 1 of 1
1
Join the Conversation
Add a Comment
 
Copyright 1999 - 2016. Slickdeals, LLC. All Rights Reserved. Copyright / Infringement Policy  •  Privacy Policy  •  Terms of Service  •  Acceptable Use Policy (Rules)  •  Interest-Based Ads
Link Copied to Clipboard