PDA

View Full Version : Excel to CSV query importing in to an access DB


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.

codyman144
Jan 21, 2009, 12:22 AM
You Cannot use complex formulas like IF in a CSV file. CSV is basically like data only...

What you want to do is take your excel data do a file copy and paste special as values in the CSV format. That should work I hope...