importing data


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: importing data

  1. #1
    Join Date
    Aug 2005
    Posts
    2

    importing data

    Hi! I am trying to import data from an excel file into enterprise manager. I have an existing table called "agents" which contains info and I want to import more data. I have right clicked on the "agent" table and used the import wizard, but when I complete the transfer, I can't find my info. Anyone know what I am doing wrong? Thanks for any help.

    Scott

  2. #2
    Join Date
    Nov 2003
    Location
    Portland, OR
    Posts
    8,387
    Look in your database for a new table. Imports generally create a table, rather than importing into an existing one.
    Phil Weber
    http://www.philweber.com

    Please post questions to the forums, where others may benefit.
    I do not offer free assistance by e-mail. Thank you!

  3. #3
    Join Date
    Aug 2005
    Posts
    2

    reply

    Can I not import into an existing table?

    Thanks!

    Scott

  4. #4
    Join Date
    Nov 2003
    Location
    Portland, OR
    Posts
    8,387
    You can, but not by right-clicking on the desired table. Instead, you must explicitly choose the destination table during the "Select Source Tables and Views" step of the DTS Import/Export Wizard. Expand the Destination column and you'll see that the wizard imports into a new table by default.
    Phil Weber
    http://www.philweber.com

    Please post questions to the forums, where others may benefit.
    I do not offer free assistance by e-mail. Thank you!

Similar Threads

  1. data containers in a .NET distributed app
    By Daniel Pratt in forum .NET
    Replies: 27
    Last Post: 09-16-2002, 11:36 AM
  2. Data Access Strategy
    By Karl Robinson in forum VB Classic
    Replies: 0
    Last Post: 07-16-2001, 01:55 AM
  3. Importing data.. sigh
    By Dana in forum Database
    Replies: 3
    Last Post: 10-09-2000, 05:13 PM
  4. Re: Importing data.. sigh....
    By Dana in forum Database
    Replies: 0
    Last Post: 10-06-2000, 01:53 PM

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