Import selected columns from Excel to SQL


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Import selected columns from Excel to SQL

  1. #1
    Tim Guest

    Import selected columns from Excel to SQL


    I would like to import selected columns from Excel to a SQL table. I was trying
    to use the DTSWIZ utility, but it only sets up the selecting of the columns
    from the Excel worksheet. I would like to know how to finish the script to
    complete the task.

    Thanks,

    Tim

  2. #2
    David Satz Guest

    Re: Import selected columns from Excel to SQL

    another way to do this is to build INSERT and update statements w/in Excel
    using the CONCATENATE() toreference the cells

    --
    HTH,
    David Satz
    Principal Web Engineer
    Hyperion Solutions
    "Tim" <Tim.Shirey@attws.com> wrote in message
    news:3db69b65$1@tnews.web.devx.com...
    >
    > I would like to import selected columns from Excel to a SQL table. I was

    trying
    > to use the DTSWIZ utility, but it only sets up the selecting of the

    columns
    > from the Excel worksheet. I would like to know how to finish the script to
    > complete the task.
    >
    > Thanks,
    >
    > Tim




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center