views:

43

answers:

1

Hi,

I am trying to import data from a CSV file to a SQL Server 2008 table. Data upload is working, but I want to import only selected columns, not all, and add them to a a new table, of same no. of columns, using the wizard, but its not happening, the wizard is selecting all the columns.

So is it possible using wizard that I only import selected columns.

Thanks

A: 

If you are using the Import / Export wizard, 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.

u07ch
That works in when importing from table, but when importing from CSV, even I ignore columns, still they are being imported.
kaibuki
Strange that works for me; but so does this method on the "Choose a Data Source" step of the wizard on click into the advanced tab highlight the column you are interested in and click the delete button below the list.
u07ch