A
Ayyad K
Hey,
I have been trying to import from a specific sheet/range in an excel
file using an TransferSpreadSheet Macro
Now this sheet is a Summary sheet if you will, so most of the cells
refer back to other sheets from the same excel file
Cells look Like this for ex: ='Actual Time'!A15
However if the cell it is referring to is blank then it gives a
zero---- But I want it to stay blank
so i changed them to Any of the following
=TEXT('Actual Time'!A15,"")
=IF('Actual Time'!A15="","",'Actual Time'!A15)
=TEXT('Actual Time'!A15,)
Anything to give me a blank, but with those formulas there, Access
simply refuses to import the entire row that that cell is on.
And gives me the error (information box) that says it was unable to
append all the data to the table. And Adds that "The contents of fields
in 0 records were deleted, and 0 records were lost due to key
violations. After giving a brief (useless explanation for each error)
it asks if I want to proceed anyway.. yes or no... it does not make a
big difference, non of that data comes through
So Is there a way to let access accept Feilds whos formulas result in
blanks or "".... because if it was just blank access has no problem
importing it
Srry for the length post,
Any help is appreciated
I have been trying to import from a specific sheet/range in an excel
file using an TransferSpreadSheet Macro
Now this sheet is a Summary sheet if you will, so most of the cells
refer back to other sheets from the same excel file
Cells look Like this for ex: ='Actual Time'!A15
However if the cell it is referring to is blank then it gives a
zero---- But I want it to stay blank
so i changed them to Any of the following
=TEXT('Actual Time'!A15,"")
=IF('Actual Time'!A15="","",'Actual Time'!A15)
=TEXT('Actual Time'!A15,)
Anything to give me a blank, but with those formulas there, Access
simply refuses to import the entire row that that cell is on.
And gives me the error (information box) that says it was unable to
append all the data to the table. And Adds that "The contents of fields
in 0 records were deleted, and 0 records were lost due to key
violations. After giving a brief (useless explanation for each error)
it asks if I want to proceed anyway.. yes or no... it does not make a
big difference, non of that data comes through
So Is there a way to let access accept Feilds whos formulas result in
blanks or "".... because if it was just blank access has no problem
importing it
Srry for the length post,
Any help is appreciated