|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | Need help with exporting data to microsoft excel? | |
| kingfish 7/17/2009 5:52:14 AM | Wondering what options do I have when it comes to exporting data to microsoft excel? Don't expect anybody to explain how to use microsoft excel. Basically want to know easy way to get data into microsoft excel for mining. Been playing around with Jeff Track profile report. Was able to export to microsoft excel. Wasn't able to get jockey and trainer names to line up. Any advice would be greatly appreciated. kingfish
| |
| dvlander 7/17/2009 11:44:44 AM | If you have Excel 97, the easy way is to open the PL-Profile text file within Excel. Then, examine the latest mapping thread from Jeff so you can correctly title the individual fields. After that you can save it as a workbook and then mine away. However, you have to have Excel 97 or there are too many fields for the earlier versions to handle.
| |
| kingfish 7/17/2009 5:10:38 PM | Thanks! I do have a old copy of Excel 97. Just recently bought Excel 2007. Will definitely give it try. kingfish
| |
| ryesteve 7/17/2009 11:14:53 PM | Don't try it with '97... I'm pretty sure Dale meant 2007. You need the capacity to handle lots of columns.
| |
| dvlander 7/18/2009 7:55:47 PM | You're right, Im meant Excel 2007. Dale
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |