AS/400 Spooled Files

[Crow_23]

I know nothing about ODBC, servers....but I do know that SQL can be used as well as Access to pull information out of datawarehouses. As of now my process is to go into BPCS, spool a file, print it out, and manually type in #s into Excel. This is my second internship for school, and at my first internship SQL was established and I did not have to do this, so I know that manually typing data into Excel is NOT the way to go. Can anyone guide me in the right direction as to some information I need to know about SQL and the database to get something going in Access or a website possibly with that information. I have 5 months left in my internship and actually want to learn something here, and learning/applying SQL would be awesome. Thanks everyone.

Ed

 

[IGLESIAS]

I have this same problem... D/L from JDE to a spool file... import it to excel but I get some data that is not linear...

what I mean by linear is that for value A on row one... I get the corresponding quantity on a different row...

does anybody know how to get this fixed?