Excel to CSV query importing in to an access DB
I'm having a problem when I convert an excel ss to a CSV file.
I have the following formula in excel =IF(D5="Transfer off",IF(COUNTIF(Sheet3!$H$3:$I$36,Sheet1!C5),VLOOK UP(Sheet3!$H$3:$I$36,2,0),""),IF(D5="Transfer on",C5,""))
I'm converting to CSV to import in to an access database and when I do this I'm experiencing a lot of blank lines upon importing. I opened the CSV file in notepad and noticed a lot of "" lines further down. What I think I need to do is replace the "" with something else in the spreadsheet that will return an empty field and not show the "". I've tried replacing it with Empty, blank, null etc but it isn't doing anything.
Does anyone know what I'm doing wrong or point me in the right direction to fix this problem.