Access to Excel Transfer

[tlaksh]

I am using the TransferSpreadSheet Method to transfer information from a Access Report to Excel. I use a query in access for the information. But there are column data on the report that is changing value in excel...

for example a col with data 4a is changing to 1.666667. Why is this happening....?? Any solutions.

Also once this data is in excel i am using a template to get the data in a format requested by the user....But each time I open this template it comes with a Ref error and says cannot read from file....unless I change every cell formula and remove the brackets, quotes and Ref# signs...Any generic way to rectify this....

I am now working with access 2000 and excel 2000.

Thanks
Lakshmi.

 

[scking]

This sounds like Excel is displaying your data in a numeric format rather than text. Try entering a ' just prior to the cell data and see if you 4a value reappears. Excel is famous for wrongly guessing what type data you have based on rules of thumb. We have code similar to the following:

02541
32161
45A16
Which Excel determines to be numeric in some cases and text in other cases. I have written a few Excel macros to help identify this problem.

If I use 1799372034444, a FSN it sometimes interprets it as a numeric and displays it in scientific notation.

If you are using a template look at the format of the cells in the offending column and determine if that really is correct.


-------------------------------------
scking@arinc.com
Try to resolve problems independently
Then seek help among peers or experts
But TEST recommended solutions
-------------------------------------

 

[tlaksh]

Nope that did not work..All other rows in the column with 4b, 4c as values work fine....

Actually the template is another problem...this is not exporting to a template...just a plain excel file.