Upload excel (multiple sheets) data into sql server

Discussion in 'ASP General' started by Pk, Jul 16, 2006.

  1. Pk

    Pk Guest

    Hi,

    I have an data in multiple excel worksheet which i wan to upload into
    sql server through asp code.

    Please help me how can i use
    server.createobject("excel.application")

    help me its urgent with code

    Thank you very much in advance.
    Pk, Jul 16, 2006
    #1
    1. Advertising

  2. Automation of Office objects on your server isn't very advised. How about
    creating a DTS package to import the data? You can use an ODBC connection
    to extract data from Excel.

    Ray at work

    "Pk" <> wrote in message
    news:...
    > Hi,
    >
    > I have an data in multiple excel worksheet which i wan to upload into
    > sql server through asp code.
    >
    > Please help me how can i use
    > server.createobject("excel.application")
    >
    > help me its urgent with code
    >
    > Thank you very much in advance.
    >
    Ray Costanzo [MVP], Jul 17, 2006
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Rathtap
    Replies:
    0
    Views:
    2,133
    Rathtap
    Jun 30, 2003
  2. Harry Zoroc
    Replies:
    1
    Views:
    915
    Gregory Vaughan
    Jul 12, 2004
  3. Rohan
    Replies:
    2
    Views:
    308
    Neil Cerutti
    Aug 7, 2007
  4. Carl Corcoran
    Replies:
    1
    Views:
    251
    Bob Barrows
    Nov 12, 2003
  5. RichpU

    Export to multiple excel sheets

    RichpU, Dec 9, 2004, in forum: ASP General
    Replies:
    1
    Views:
    176
    Melissa
    Jan 3, 2005
Loading...

Share This Page