[AccessD] Fascinating (but schtupid)

You CAN have the first 2 characters of a CSV file be "ID".

It is just that Excel can't handle the file properly.  You can do anything else you want with the 
file with no problems, just not open it directly with Excel.

That;s only one of lots of gotcha's with opeing CSV files in Excel.  The last problem I had was 
with a file containing the string "2 Sep" in several places (a technical description in oil palm 
leaf analysis). Excel insisted on turning them into  dates and saving them as numbers when 
the file was edited  and saved. :-(

-- 
Stuart

On 6 Feb 2012 at 15:58, 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