Import csv file vb

I have a csv file that needs to be imported into sql server using vb. SqlConnection objConn. Open ' Make sure the. CSV file exists: If File. ExecuteNonQuery objConn. Answered by Lord Soth 4 in a post from 15 Years Ago. Loren Soth Jump to Post. Loren Soth. How do I do that? I'd really appreciate any help. Ninleg, Here is a sample: I have a Categories. Use the following code to import. Click button to select a cell where you want to output the data;. Then click Browse button to open the Select a file to be inserted at the cell cursor position window;.

And the CSV file will be inserted into the specific location you need. Click to know more about this Insert File at Cursor feature…. Download and free trial Kutools for Excel Now! Note: The other languages of the website are Google-translated. Back to English. Log in. Remember Me Forgot your password? Password Reset.

Could someone help me plz! Community Bot 1 1 1 silver badge. It is difficult to offer solutions when the problem statement is simply, "it doesn't work". Please edit your question to give a more complete description of what you expected to happen and how that differs from the actual results. See How to Ask for hints on what makes a good explanation. I couldn't edit so I'm trying to answer here. You only need to use Set where you define an object reference.

Since Wb is a string, you don't use Set — Dave. I erased "Set" but I still got the same mistake — shinpencil. Add a comment. Active Oldest Votes. Values should be used to differentiate between general, text, etc. Activate With ActiveSheet. Comments Dear Mr. Sherman, I am looking for a way to open.

I found your site and think that you could maybe help me… I was given a macro similar to yours see below , with the command. Add With ActiveSheet. This is great macro. I am trying to adapt to my requirement but having some problem.

Is there an alternative to resolve this issue? I am trying to import a text file to a specific worksheet. Thank you for this helpful article! It saved a lot of time for me! Leave a Reply Cancel reply Your email address will not be published.