bumble1290
Jan 20, 2009, 10:25 PM
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),VLOOKUP(S heet3!$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.
I have the following formula in excel =IF(D5="Transfer off",IF(COUNTIF(Sheet3!$H$3:$I$36,Sheet1!C5),VLOOKUP(S heet3!$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.