[AccessD] Access 2K to Excel changes field format

Hi Patricia

It's not Excel, it's much more Basic(!) than that, and Access will behave similarly.
D in a number (string) is equivalent to E as used for scientific notation:

? 456E123
 4.56E+125 

? 456D123
 4.56E+125 

This may present a well known trap if you don't know what you are doing when using IsNumeric() for testing for numerics only:

? IsNumeric("456E123")
True
? IsNumeric("456D123")
True
? IsNumeric("456H123")
False

You could try importing them to Excel this way:

Left("66005769905A01", 11) & Right("66005769905A01", 3)

That should cause Excel to interpret this as a compound string.

/gustav

>>> Patricia.O'Connor at otda.state.ny.us 09-03-2006 23:35 >>>
The query is used to put data into an Access report. The single quote
shows up both in the Access report and the excel cell. That does not
look good nor does it make sense to user seeing this.  If I try to get
rid of the single quote in the Access report then it gets reformatted in
excel when using the Analyze in Excel. The field is specified and stored
as text in both access and oracle and specified text in Excel.  

Here are some examples.  When I use the original query in Access that
creates the report directly in excel it did not mess up the ID.    
66005769905A01                  66002730270C01   
66006665460J01                  66001747189H01
66007974120D01              66001215257F01

If  while looking at the access report and I click Analyze with Excel it
does change the ID.
66005769905A01           66002730270C01
66006665460J01            66001747189H01
6.6008E+11                66001215257F01


Why would it mess up only certain id's and why when creating from Access
report? Is there a way to tell if whether the wrong  version of the
analyze option is being used.  I do have Access 97 and 2K on this
machine.