<div>
hi,<br />
<br />
you can use the Import / Export wizard in SQL enterprise manager to straight away import them into a table.<br />
when you get to Select Source Tables and Views click on the button &quot;Edit Mappings&quot; on the bottom left of the screen. That opens column mappings screen; on the destination column select Ignore to remove the column you don't want to import.<br />
<br />
hope this helps<br />

</div>


hi,

you can use the Import / Export wizard in SQL enterprise manager to straight away import them into a table.
when you get to Select Source Tables and Views click on the button "Edit Mappings" on the bottom left of the screen. That opens column mappings screen; on the destination column select Ignore to remove the column you don't want to import.

hope this helps


<div>
I have to automate code with C#. &nbsp;Sorry, this solution won't necessarily help because of the process involved. &nbsp;How can I import specific column names using C#?
</div>


I have to automate code with C#.  Sorry, this solution won't necessarily help because of the process involved.  How can I import specific column names using C#?

<div>
<div class="content wysiwyg-content">
I would like to import information from a CSV file into a SQL Server table. &nbsp;The issue that I am dealing with is I don't want to use all the fields in the CSV, only a few. &nbsp;I would like to pull columns with the following header names, namecol, addresscol, agecol. &nbsp;There are a total of 10 columns in the CSV file, but I only want to pull the 3 that I mentioned, so what exactly do I do to pull only the 3? &nbsp;I do not want to use the index parameter like [0], so what do I do?
</div>
</div>


I would like to import information from a CSV file into a SQL Server table.  The issue that I am dealing with is I don't want to use all the fields in the CSV, only a few.  I would like to pull columns with the following header names, namecol, addresscol, agecol.  There are a total of 10 columns in the CSV file, but I only want to pull the 3 that I mentioned, so what exactly do I do to pull only the 3?  I do not want to use the index parameter like [0], so what do I do?

Working with CSV files in C#

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).