jwcolby
jwcolby at colbyconsulting.com
Mon Feb 6 14:49:20 CST 2012
Well there ya go. So even though they use a SLK extension, they make a decision to treat any text or csv file with ID in it as the first two characters as if it were a SLK file. Ya ever wonder how much they pay the geniuses that do this kind of stuff? John W. Colby Colby Consulting Reality is what refuses to go away when you do not believe in it On 2/6/2012 2:32 PM, Heenan, Lambert wrote: > SYmbolic LinK (SYLK) file... > http://en.wikipedia.org/wiki/SYmbolic_LinK_(SYLK) > > Lambert > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby > Sent: Monday, February 06, 2012 1:57 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Fascinating (but schtupid) > > Oh MAN did you read this? If the first two characters of a CSV have 'ID' Microsoft unilaterally decides it is a SLYK file? First of all, what is a SYLK file? And why doesn't MS fix this instead of making the entire world work around this *Microsoft* problem? Or have they? Notice that the "Applies to" does not include 2007 or 2010. > > John W. Colby > Colby Consulting > > Reality is what refuses to go away > when you do not believe in it > > On 2/6/2012 10:58 AM, Mark A Matte wrote: >> >> Here is another 'no-no': http://support.microsoft.com/kb/323626 >> >> >> Last week I exported from Access to CSV...and the recipient said the file was corrupt...With a little research it was determined you CANNOT have the first 2 letters in a CSV file be 'ID'... they can be 'id'...just not capitalized. >> >> Just adds to the list of gotchas lurking in MS. >> >> Mark A. Matte