MajP,
That is basically how I do it now... But with thousands of items stacking on top of each other, it is incredibly slow, especially a few months in.
I am looking for a way to keep constant information like category, item descriptions, etc... and just add the new sales data as additional...
I am pretty new to access but am trying to replace a very convoluted workflow with a simpler, more efficient one. Any input would be appreciated. Here is the situation
Our computer system gives me a text file, between 6000 and 33000 lines, with about 40 columns.
Each row is an item number...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.