Ask Experts Questions for FREE Help !
Ask
    bumble1290's Avatar
    bumble1290 Posts: 10, Reputation: 1
    New Member
     
    #1

    Jan 20, 2009, 10:25 PM
    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.
    codyman144's Avatar
    codyman144 Posts: 544, Reputation: 31
    Senior Member
     
    #2

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

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Query on Excel [ 2 Answers ]

I'm really confused now about creating a chart in Excel - yesterday I thought I was an expert! Anyway, please help me with the following: I want to create a scatter diagram (displaying x and y values at any one time). What I get is a vertical kind of diagram, with the values of X and Y. ...

Run MS access query as exe [ 1 Answers ]

Hi, I have to run few queries one after another. I created a form, so now I can run them in sequence with just 1 click of a button. It there a way that I can start running those queries by just loading the form and not clicking any button. My main aim is to have a schedule task so Access...


View more questions Search