locked
i need to know how i can past some values from any table like excel or word table to rows in sql server 2008 database table ??? RRS feed

  • Question

  • my scenario is :

    i have some table on excel include column have 100 rows okay , i want put this data in my database table , i try to copy and past it , but its only give me the first value , i need information about wich topic i have to look for to help me about that

    Tuesday, April 6, 2010 4:20 PM

Answers

  • Use Import \ Export wizard or SSIS or bcp or BULK INSERT.
    Vidhya Sagar. Mark as Answer if it helps!
    • Marked as answer by HESHAM HEMDAN Wednesday, April 7, 2010 7:21 AM
    Tuesday, April 6, 2010 5:09 PM

All replies

  • Use Import \ Export wizard or SSIS or bcp or BULK INSERT.
    Vidhya Sagar. Mark as Answer if it helps!
    • Marked as answer by HESHAM HEMDAN Wednesday, April 7, 2010 7:21 AM
    Tuesday, April 6, 2010 5:09 PM
  • aha i'm work now on bulk , thank you anyway , i will try bulk and see
    Wednesday, April 7, 2010 7:21 AM
  • aha i'm work now on bulk , thank you anyway , i will try bulk and see
    Wednesday, April 7, 2010 7:21 AM