Gary Kjos
garykjos at gmail.com
Tue Nov 9 12:15:22 CST 2010
Write out a delimited CSV file which most systems will default to opening in Excel. GK On Tue, Nov 9, 2010 at 10:19 AM, Rocky Smolin <rockysmolin at bchacc.com> wrote: > Dear List: > > The client below is using my E-Z-MRP system, but had me develop a fairly > elaborate export of some of the data into a spreadsheet in a format that > they were used to using. While he agrees that using this spreadsheet is not > the best solution, at the moment it was easier than trying to effect change > among the users. > > However, he has now run into a problem: the 256 column limitation of Excel > 2003, a limitation which apparently is greater in 2007. The app is in 2003 > and, because it's a standard distributed product it is impractical to > upgrade to 2007 (also, I'll be dipped if I'm going to be forced to develop > and support a product in 2007 which runs like a spotted dog in 2003). > > So the question is how to reference the Excel 2007 library in the app > instead of the 2003 Excel library? > > MTIA > > > Rocky Smolin > > Beach Access Software > > 858-259-4334 > > Skype: rocky.smolin > > www.e-z-mrp.com <http://www.e-z-mrp.com/> > > www.bchacc.com <http://www.bchacc.com/> > > > > > > > _____ > > From: > Sent: Tuesday, November 09, 2010 1:24 AM > To: 'Rocky Smolin' > Subject: Issues with Report Download > > > > Rocky, > > > > Sorry for not being in contact regarding the download of the product > structure that I mentioned before, I have been hard at it correction and > inputting data into the system, for now I think we should not spend any more > time on this download as I seem to be managing okay using the Database > itself. > > > > I do however have a minor problem with the MRP download report. We have now > inputted all of our products into the system, there are now 221 assemblies > being used. > > > > On the MRP Shortage sheet in Excel there are a number of columns giving Part > details, Stock, Shortages etc. Then the BOM's for all parts is cross tabbed > to the right of the sheet and the where used qty updated against each item. > > > > Problem is we now have so many assemblies we have run out of columns in > Excel, as we are using Excel 2003 version for the download and the column > numbers go from A to IV this is 256 columns out of this 66 columns are taken > up with data before you get to the assemblies then 221 assemblies that's 287 > columns required with only 256 available in excel, the download creating an > error at this point. > > > > We could of course economise in the first 66 columns as some of the old date > columns could be taken out (Jan 2010 to Sept 2010 for example) but it would > be better if we could run this download into Excel 2007 file rather than > 2003 version as Excel 2007 has thousands of columns available. > > > > Currently we can not select an Excel 2007 version file from the front end. > Can this be amended? > > > > Regards > > > > Howard > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- Gary Kjos garykjos at gmail.com