Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Posts
    31

    Unanswered: read data from excel

    can u suggest me the methods or give me some help on how to read data
    from excel?
    how can i do it?

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    store your excel sheets as cvs datasets and then use sqlldr

  3. #3
    Join Date
    Nov 2004
    Location
    Temple University
    Posts
    36

    Cool

    Drop it into access and just do an append....

  4. #4
    Join Date
    Jan 2004
    Posts
    31

    hi

    thanks fro helps ,but i want to read data from excel with odbc

  5. #5
    Join Date
    Nov 2004
    Location
    Temple University
    Posts
    36

    Cool

    If you want to have eXcell connect to the database and select data, then use the data menu - import/export data - new database query.

    If you want to go the other way, you can not do it in a one step process, you must go through an odbc connector like access.

    HTH
    Peter

Posting Permissions

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