transferring data using asp

Results 1 to 2 of 2

Thread: transferring data using asp

  1. #1
    Join Date
    Dec 1969

    Default transferring data using asp

    hi!<BR><BR>i want to use my excel spreadsheets to input data in my sql server database. i know it can be done using data transformation services wizard but the problem is that i want to do it remotely using an asp. can anybody help?

  2. #2
    Join Date
    Dec 1969

    Default RE: transferring data using asp

    you should be able to set up an ODBC Excel Driver to point to your spreadsheet. use the column headers as in the same manor as fields in a table, and write a script that pulls the data from the excel spreadsheet and then inserts the data into the sql server table.<BR><BR>open the connection the the spreadsheet.<BR>get the appropriate recordset.<BR>connect to the sql server db.<BR>loop through each record in the recordset.<BR>while looping, execute an insert statement to the sql server db.<BR><BR>this should do it for you.

Posting Permissions

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