Results 1 to 5 of 5
  1. #1
    Join Date
    May 2003
    Posts
    25

    Unanswered: database to excel... and vice versa

    How can I import/export data from Microsfot SQL to an excel spreadsheet when MSSQL is not on the machine I am working on...( it is on the network)??


    thanks al

  2. #2
    Join Date
    Jul 2002
    Location
    IA
    Posts
    28
    BCP from the command prompt. You have to have the sql client utilities installed on the workstation. BCP will let you get one table at a time.
    Thanks,
    Jason

  3. #3
    Join Date
    May 2003
    Posts
    25
    Originally posted by barneyrubble318
    BCP from the command prompt. You have to have the sql client utilities installed on the workstation. BCP will let you get one table at a time.

    Jason,

    I am not quite sure what BCP is could you explain this more... thanks for the help i really appreciate it.

  4. #4
    Join Date
    Jul 2002
    Location
    IA
    Posts
    28
    http://support.microsoft.com/default...kb;en-us;69286

    You have to have SQL client tools and a valid account on the server. Books online that installs with the client tools has a lot of info. Give it a try and come back with questions.

    From a command prompt:

    bcp databasename..tablename in test.xls -Usa -P -Ssvr
    -U is username
    -P is password
    -S is server name all of this IS case sinsitive.

    You can get some help from just typing 'bcp' at a command prompt.
    Thanks,
    Jason

  5. #5
    Join Date
    Jul 2002
    Location
    IA
    Posts
    28

    DTS or BCP

    Does your spreadsheet have more than one 'sheet' then DTS is the way to go if you try to get to the second or more sheet. BCP won't look at more than the first sheet.

    BCP is faster than DTS, but DTS gives you more control.
    Thanks,
    Jason

Posting Permissions

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