REPEAT IMPORT OF DATA
Posted by steve morgan on May 05, 2001 12:01 PM
Each month I have to import a file from our antiquated UNIX system and convert it to an excel spreadsheet. I open the file using excel and then have to space out the columns and change the column type (date and text and general). Then I have to bring the data into excel and do some more manipulation.
Is there a way to set up a repetitive action so that I don't have to re-invent the wheel each month?=
Thanks to all