[AccessD] FW: Issues with Report Download

That might work - gotta see what kind of formatting and formulas he'd lose
that way.

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
Sent: Tuesday, November 09, 2010 10:15 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] FW: Issues with Report Download

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

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com