PDA

View Full Version : a FIX for 2005 exporting functions


gkaste
07-23-2004, 07:43 AM
Perhaps some others of you have noticed that 2005 exports data differently from other programs. In my particular case, it was the inventory item list.

2004 exports like this:

ItemID, Component1, QuantityNeeded1, Component2, QuantityNeeded2, Component3,....

2005 exports like this:
ItemID, Component1, QuantityNeeded1
ItemID, Component2, QuantityNeeded2,
ItemID, Component3,.....


This posed a problem for me. Yesterday, I wrote a simple access program that takes the excel file(you need to convert it to an excel file, or make some program changes) and reformats the data.

This isnt an all around fix, because I tailored it to a custom export report we designed around the inventory item list, and to work around some other steps already done by us in the export(like convert to excel file and such). However, you can easily make some modifications to this, if you know what you are doing, and have it work for your report.

I hope someone else can make use of this.

Garrett

gkaste
07-23-2004, 07:57 AM
The file.