Importing Blank/Empty Excel Cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have an excel sheet which performs a number of calculations. I then import
the answers back into access. In my excel sheet, I need to use IF statements
to catch errors. The result being, that I have set a number of the cells in
the range that I import set to "" eg =if(A2<>0,A2,"").

Access is unhappy importing these 'blank' cells. Is there a way I can sort
this out in either access or excel?

Many thanks
Tarryn
 
You need to format everything as text. instead of "" put " " and ensure all
numeric values are output as text eg: TEXT(A2)(?) so your formula will look
like
=IF(A2<>0,TEXT(A2)," ")

I'm not sure about the TEXT , but I have used FIXED quite successfully.
 
Hi Tarryn,

Access is usually more expressive than just looking happy or unhappy.
Without knowing what it's actually telling you one can only guess at the
cause.

Have you thought of using conditional formatting to flag errors?

Have you tried returning a text or numeric value (e.g. =IF(A2<>0,A2,0).
If you want to keep the cells looking empty, use a custom number format
that doesn't display zeroes, e.g.
#,##0.00;-#,##0.00;
 
Back
Top