Doug Steele
dbdoug at gmail.com
Tue Nov 9 14:06:17 CST 2010
Hi Rocky: Have you tried your db on a system with Office 2007? I have Access 2003 database with Excel exports which work just fine when run on Office 2007 without any changes. The db is an .mdb file, not .mde. Access 2003 seems to automatically update the internal references from Excel 11 to Excel 12 (or is it 13?) as needed. Doug On Tue, Nov 9, 2010 at 8: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 >