Imported Data - misinturpretted

[Guest]

Could some one help if possible,

I have an access database that draws data from an ODBC connection and sends
it Excel.

The problem arise when certain data is returned, there is are some values
that are codes e.g 16D32 , 11E23, that when they are returned to Excel ,
excel handles them as some kind of mathematical function and they are
displayed as 1.6E+33 and 1.1E+24

If you format a cell manually to be a text cell and type these values in it
is ok but on a generalised cell you get this problem, The problem is the
automatic transfer from access to excel won't let me format this type of data
as text.

Any workarounds or ideas would be great

Thanks

Jai

 

[Guest]

Try to export from Access in .txt format and import this text file into Excel!

Regards,
Stefi


„Jai_Friday†ezt írta:

 

[Guest]

Thanks for the input Stefi,

The helps as a temporary work around, however I need to look into a access
function (guess I will post it on the access area)

there is a Cstr function that should convert the value to a string but it
doesn't work, there probably is something else that can be used

Cheers again

Jason

 

[Guest]

Hi

Are you opening the Access table/query using ODBC from within Excel - using
Get External Data?

Andy.