Hello, I have a worksheet with a pivot table that I'm trying to import into Access but Access has a hard time decifering the information. I have linked a second worksheet to the source and reformatted all the cells to read into a simple spreadsheet for better importing results. However, all my links return a value of zero if the cell in source sheet is blank. I would like this returned value to be blank if the source cell is blank. I have tried tools/options/view and deselected zero values but Access still reads these cells as zero. Is there a way to override this default? Please help.
Thank you,
David
Thank you,
David