Is the text file in comma separated values?
Thank you, Mitch Lawrence Senior Applications Analyst - Advanced Report Writer General Financials Support CHRISTUS Information Management ': 361.881.3408 7: 361.888.6117 *: 361.549.8456 )AIM: a1d13 )MSN: [EMAIL PROTECTED] *: [EMAIL PROTECTED] Send a "thank you" <http://intranet.christushealth.org/spiritBuck/> to someone! _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Brungardt Sent: Friday, January 26, 2007 11:29 AM To: [email protected] Subject: [Talk] .txt to .xls I'm trying to find a way to convert text files with values that contain leading zeros into Excel files that will keep those leading zeros. I can manually do this via Excel's Import wizard but really need to find a way to script it. Command line, VB, something other than manually! Is there any hope? Thanks! Paul Paul Brungardt Clinical Analyst HaysMedicalCenter PH: 785-623-2196 PG: 785-650-5989
image001.gif
Description: image001.gif
