Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
revdnrdy
Posting Yak Master
220 Posts |
 Posted - 2008-11-18 : 12:55:11
|
| Hello;I am working with SQL 2005.I have a spreadsheet which requires appending an underscore to all the fields in a column A.. ie 1234 becomes 1234_I would like to use sql to do this rather than manually do it? I know you can simply type =A&"_" in excel but am curious if I can have sql do it while importing the spreadsheet into the db. The _ has to be appended before the data is inserted.Is it possible to use the import wizard to customize imports in this way? I would have to append the underscore after the table is created but before data is inserted. So I guess this would happen dynamically. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-18 : 13:32:38
|
| you can specify custom transformation in export import wizard to add _ |
 |
|
|
revdnrdy
Posting Yak Master
220 Posts |
Posted - 2008-11-18 : 14:05:57
|
| I noticed in the import wizard it says"Write a query for the specific data to transfer"Is that what you mean?Could you give a simple example of what you mean? |
|
|
|
|
|
|
SQL mgmt studio 2005 import wizard