RE: INVENTORY HISTORY FILES EXPORT TO EXCEL

Access would probably be a good, easy first choice.  Does not have the
65,534 limitation.  But it does suffer from a 2GB per database
limitation, in practical use.  This is actually fairly large...if 2GB is
a problem, you could export a year at a time to separate databases.
Otherwise, you're into SQL land on the Microsoft side of things.

You can then select/filter the raw data in Access queries and export to
Excel if you're more comfortable working there, as many are.  Once your
queries work, you can change them to SQL Pass-thru and they'll run MUCH
faster, as they bypass some of the internal Access translation
layers...much faster. 

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of
DaleGindlesperger@xxxxxxxxxxx
Sent: Thursday, July 21, 2005 8:43 AM
To: MAPICS ERP System Discussion
Subject: Re: INVENTORY HISTORY FILES EXPORT TO EXCEL







Peter Vidal wrote:

"Another limitation, Atul, is that Excel can hold a specific number of
records (I think that the maximum row limit is 65,534, do not ask me
why).

You can use MS Access...".

The 65,534 is a register limit, "FFFF" is 65,536.  Don't they teach
hexidecimal anymore?  (I'm showing my age!)

I don't know if Access has the same limitations.  We don't use it, we
use the iSeries as our database management system.  However, a Microsoft
partner also sells a package called FRx that has been in the MPower Expo
for a couple years, that may also be an alternative, depending on what
information they need - it sounds like an accounting issue in the
initial e-mail.  They may NOT need to pull all of IMHIST in (that would
be horrendous for us, we have almost 3 million records written to IMHIST
every year).  There's more information is available at
www.frxsoftware.com.  We will be looking at this package ourselves
later.

Dale Gindlesperger
IT Manager/Special Projects Leader
Fleetwood Folding Trailers, Inc.
258 Beacon Street
Somerset, PA  15501



_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post
a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/mapics-l.