Loading csv file directly into workbook

Posted by Duncan on December 05, 2001 7:48 AM

I have a csv file and which to load it directly into a workbook (containing multiple worksheets) as a new worksheet.
I know that I could open it and then copy the data across but this seems clumsy
Any ideas?
Thanks
D.

Posted by Juan Pablo G. on December 05, 2001 8:21 AM

If yo have Excel 2000 or higher, Microsoft has added a new function in "Get External Data", that allows you to import directly from a text file to a current sheet (Or a new one) without doing the extra steps.

Juan Pablo G.