I need blank fields returned from links to blank cells

donor · Apr 8th, 2002, 06:06 PM

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

Anne Troy · Apr 8th, 2002, 07:10 PM

You might want to automate this...

Pull your file into Excel. Run an update query that replaces all values of zero with null.

Apr 8th, 2002, 07:10 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	You might want to automate this... Pull your file into Excel. Run an update query that replaces all values of zero with null. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 8th, 2002, 06:06 PM	#1
donor New Member Join Date: Apr 2002 Posts: 1	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