[AccessD] Excel to Access

Same kinds of problem sending data to Excel here too.  Job numbers have a 2 
digit year (will they never learn...) an office city character and then a 3 
digit sequential number.  A 2005 Vancouver job number might be 05V123 and 
presents no problem.  Excel converts Edmonton jobs to an exponential number. 
  I can explictly define the field format in a template file and use 
automation to always write to that template file or set the cell format on 
the fly, also with automation.

The 2003 version of Excel places a distracting green triangle at the upper 
left of the cell to flag the fact that you've messed up the formatting of 
the cell, then, if the cell is selected you get a little 'tool tip' with an 
exclamation mark which on mouse over gives a further tool tip telling you 
that you're an idiot and the cell contains text and a context sensitive drop 
down menu inviting users to completely mess up the text.  I guess I'd better 
figure out how to use automation to tell it to 'Ignore the Error' because 
users are invited to fix this number formatted at text, or at least password 
protect the column.  Give me Excel 97 back please.



Ciao
Jürgen Welz
Edmonton, Alberta
jwelz at hotmail.com



>From: "Jim Dettman" <jimdettman at earthlink.net>
>
>John,
>
>  I've had problems the other way to.  Had a text field in Access with a
>store number in it.  One record had
>
>'01010'
>
>another
>
>  '1010'
>
>  Two different stores (customer's data; so don't ask<g>) Upon export, 
>Excel
>would ignore the text data type and treat the column as a number.  As a
>result, the first record would end up with the leading 0 removed. Thus I'd
>end up with two records with 1010
>
>   You really need to watch what you do with Excel when you import/export.
>
>Jim.