Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Excel to CSV query importing in to an access DB (https://www.askmehelpdesk.com/showthread.php?t=306522)

  • Jan 20, 2009, 10:25 PM
    bumble1290
    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.
  • Jan 21, 2009, 12:22 AM
    codyman144

    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...

  • All times are GMT -7. The time now is 10:52 PM.