Exported Table Changes Data Values

[Marty444]

Hi there Folks,

I have developed an Access database, but none of my coworkers are willing to use it. Whenever I share data with them, I have to export a table to Excel. But, when I export a certain table, the data in one column changes. Specifically, all values in one column are increased by 1 except those equal to zero, which remain the same. I am looking for any suggestions as to why this is happening. Has anybody seen this happen elsewhere?

Thanks,
Marty

 

[Tiro Cupidus]

What are you doing to export it? Tools->Office Links->Analyze It with MS Excel has always worked for me.

 

[Marty444]

Tiro,

That fixed my problem. What a simple solution.

Thanks!