Hi Jeremy and welcome to the forum.
My initial thoughts about your requirement are:
- I have not checked the details but is looks fairly straghtforward to select the fields you want. Once you have a table you can make the column order anything you like, but ...
- the width of the table would be based on the number of suppliers and could vary from one to a very large number - which might prove interesting.
- The concept does not look like it will easily lend itself to a solution working just with the extracted table. However there may be some potential using a Summary. It depends upon the purpose for the output. If you want to export the result to a text file with long lines for which the data structure can be easily identified and read by a data conversion program I could see a way to do it, probably.
If it is for some other purpose then I think I would be more cautious about the structure.
That's the general comment.
A specific question.
Is the line format you seek in need of delimiters of some sort to satisfy your intentions for its use?
Now that I have asked the question.. I am beginning to doubt that what I am looking for is gonna really help me. The problem I have is that full file is about 101K line long. To long for excel and I have never enjoyed trying to manipulate data in Access. So I am guess am not sure what I need now...hehe. I guess what I might do is simply trap out the header and footer of each page and put just information I need into a table it might shorten it enough to get it into excel. Thanks you have got me thinking about some other possibilities.. and that is what I needed more than anything else. So far this piece of software has saved me at least 10-12 hours on one particular type of conversion from one POS system to another. I am pretty estatic about that. To answer your question, I am indeed tabling the information to be imported in our software with a conversion program.
product1 description supplier1 hisnumber1 lastcost1
product1 supplier2 hisnumber2 lastcost2
Any thoughts? /b[/quote]Hehe!
It's all in the way that you come to see things ...
Your suggestion above (but with description on every line) would be a normal extraction to a table from that report format - so far as I can see. There are couple of possible questions - the "Cross Index" supplier names for example and maybe also the multi line product descriptions but they llok quite simple after a brief glance.
If it was my conversion I would (I think, but I don't know your software's options)treat the columns from the Supplier Number and to the right as the DETAIL template records and the Product Number and Description as 2 fields in an APPEND template.
And that, other than freezing the database at some point prior to running the extraction, should be pretty close to doing the job for you I would imagine.
If that does not sound good to you let me now why and I'll seek an alternative suggestion from my previous conversion experiences if I can!
PS - Are you planning to tidy the data as you go? Or is it more realistic to leave all the codes as they are because there might have been a purpose to them the way they are?
Tidy is good and not difficult usually but may require some careful co-ordination.