Tag Archive for format

SYLK: File format is not valid

You can see the above message on attempting to open a CSV file in Microsft Excel. The cause is having “ID” as the very first characters in the file (case is important) because that causes a file type misidentification and CSV does not fit the application’s expectations for an SYLK format, an early spreadsheet file type used by Microsoft. More can be found here: http://support.microsoft.com/kb/323626.

Watch where you store your virtual machines when using VMware on Linux

My experience is with Ubuntu on this one but I have found that you need to be careful as regards the file system used by the drive where you keep your virtual machines. If it is NTFS, VMware can fail to start a VM because it cannot create a virtual memory file while it presents as physical memory to a guest operating system. Use ext2 or ext3 and there should be no problem, even if that means formatting a drive to fulfill the need. That’s what I did and all was well thereafter.

SAS/Access and Oracle Timestamp format

Until SAS 9.2, SAS/Access will not support the Oracle timestamp format. There still is no word on when 9.2 might appear so it’s over to the SQL pass-through facility…

  • As is commonly the case with places like these, all the views that you find expressed on here in postings and articles are mine alone and not those of any organisation with which I have any association, through work or otherwise. With regards to any comments left on the site, I reserve the right to reject any that are inappropriate. Otherwise, whatever is said is the sole responsibility of whoever is leaving the comment.