Results 1 to 3 of 3

Thread: SQL 2000 import

  1. 09-21-2009, 12:31 PM #1
    billibong45
    billibong45 is offline Registered User
    Join Date
    Sep 2009
    Posts
    1

    SQL 2000 import

    First off, want to say that I am new to this. I need to create a table and column names from an xls file. How do I go about doing this? Thanks for your help.
    Reply With Quote Reply With Quote
  2. 09-21-2009, 12:53 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can use DTS wizard to do it. On Enterprise Manager, right click the target database and select Import, then you can follow the wizard.
    http://databaseandstorage.blogspot.com
    http://gotodba.weebly.com
    Reply With Quote Reply With Quote
  3. 10-13-2009, 04:15 PM #3
    Island1
    Island1 is offline DBJ Author
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607

    And Once the Table is Created ...

    ... be sure to check your data types, non - null settings, etc., in the table properties ...

    Let us know if you have further questions ...

    Bill
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules