Connect your existing Source Control system to SSMS in 5 minutes
Getting started with SSIS - Part 1: Introduction to SSIS
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

Home | Ask Question

Loading

Ask in the public forum

Ask your questions in a public forum

My Blog Posts

Write SQL amazingly fast with SQL Prompt

Recent Blog Posts

  • Split Data from Excel to SQL Server Table

    Mar 9 2010 2:50AM | Report Abuse This post is not formatted correctly

    Hi there

    I have a column C1 in Excel which contains data as follows:
    C1
    ------
    111-222-3333
    mark@client.com
    Mark Ben
    Steve Ryn sryn@client.com
    222-333-4444 michael douglas
    In the above sample data, the same column C1 contains phone numbers, email address and also name of persons. And few times the combination of phones and names and email address.
    Now the challenge is split the data from this column to different columns say Phone, Email, EmployeeName. The source data is in Excel Format.
    Phones
    --------
    111-222-3333
    222-333-4444
    Emails
    --------
    mark@client.com
    sryn@client.com
    EmployeeNames
    -------------------
    Mark Ben
    Steve Ryn
    Michael Douglas
    Could somebody help me in getting this fixed. I think scripting in SSIS or T-SQL mechanism (by moving the excel data to some staging sql server table and from there we can, if possible) can be used to handle the situation but I am not much into scripting. If macros in excel are capable of doing it, I can opt for it as well.
    Thanks in Advance
    Sunny

     

    Excel
    sunny.msbi
    1186 · 0% · 9

1  Replies  

Subscribe to Notifications

Your Reply
Sign Up or Login to post an answer.

Managed Windows Shared Hosting by OrcsWeb

Copyright © Beyondrelational.com