Okay I overlooked two important parts of the test - I assumed 1) That your PC associates .CSV's with Excel and if that condition was met I should have 2) stated "open the file by double-clicking on it".
My bad, Dave "can't you read my mind?" Lum -----Original Message----- From: Jim McGowan [mailto:[EMAIL PROTECTED]] Sent: Friday, January 10, 2003 09:07 AM To: NT 2000 Discussions Subject: RE: [OT] reverse Excel Easter egg (kind of) Why would you open a text file from File\Open. M$ provided Data\Get External Data\Import Text File which worked fine for me (No Errors on your test.) and provides the opportunity to fine tune the import. Jim -----Original Message----- From: Roger Seielstad [mailto:[EMAIL PROTECTED]] Sent: Friday, January 10, 2003 7:08 AM To: NT 2000 Discussions Subject: RE: [OT] reverse Excel Easter egg (kind of) It opens fine, albeit with the error, when opening it via File | Open from within Excel. ------------------------------------------------------ Roger D. Seielstad - MCSE Sr. Systems Administrator Inovis - Formerly Harbinger and Extricity Atlanta, GA > -----Original Message----- > From: Lum, David [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 09, 2003 4:24 PM > To: NT 2000 Discussions > Subject: [OT] reverse Excel Easter egg (kind of) > > > We have someone here who does a lot of data mining, which > includes output to > a .CSV file that is later opened in Excel. Under some > conditions Excel would > generate an error opening the file, yet it was possible to > open this file in > Notepad and nothing looked amiss. This person is quite good > at complex Excel > macro/VB functions. They tried different PC's (and Excel versions) to > determine it wasn't an Excel issue and that it was the file > itself causing > problems (as well as a gazillion other ideas). > > If you have Excel, open Notepad type IDIOT (in capitals), > save it as .CSV > and open with Excel. Dimes to dollars you get a "SYLK: file > format is not > valid" message. Now make it a lower case idiot. Save, then > open with Excel. > It will open fine. > > Excel obviously takes exception to "ID" in caps as the first > two characters > of a file. The beginning of our .CSV file looked like this: > > ID,Name,Variable .... > > Kind of weird, but is it a bug or is it a feature? At some level I can > understand a program looking for "ID" at the beginning of a > file, but I'd > think it wouldn't be too uncommon for ID to be the first > column in a data > table. > > Dave Lum - [EMAIL PROTECTED] > Sr. Network Specialist - Textron Financial > 503-675-5510 > > ------ > You are subscribed as [EMAIL PROTECTED] > Archives: http://www.swynk.com/sitesearch/search.asp > To unsubscribe send a blank email to %%email.unsub%% > ------ You are subscribed as [EMAIL PROTECTED] Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe send a blank email to %%email.unsub%% ------ You are subscribed as [EMAIL PROTECTED] Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe send a blank email to %%email.unsub%% ------ You are subscribed as [email protected] Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe send a blank email to [EMAIL PROTECTED]
