Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    Kalamazoo
    Posts
    42

    Unhappy Unanswered: Data Migration from SQL to Excel

    Hi,
    I am a newbie, so please help me out with my Q.
    I am trying to get the data that are in a Sybase database into Excel sheets using the "Import External Data" thingy. There is a Table in the database which has records from 3 other tables. I am unable to get this table to be obtained in the Excel Sheet. All the datas in the database are Dynamic. Will you guys please help me out with my query.
    TIA.

  2. #2
    Join Date
    Nov 2002
    Posts
    207
    Need more info. on what eaxtly you want to do... as per current understanding, this is what can be done -

    - create one view from all three tables.
    - bcp out view in text file with field terminator as "tab"
    - load the text file in Excel

    HTH.

Posting Permissions

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