ODBC insert into Excel?

Results 1 to 3 of 3

Thread: ODBC insert into Excel?

  1. #1
    Adam Werner Guest

    Default ODBC insert into Excel?

    Quite simply, can it be done?<BR><BR>We&#039ve been able to read from an Excel spreadsheet pretty easily, but we&#039ve had no success in adding to the Excel spreadsheet either through a SQL statement or the use of the AddNew method.<BR><BR>Code that works for inserting into a database table using both techniques was adjusted for use with the spreadsheet, but with no luck.<BR><BR>I was hoping to see if anyone had successfully inserted data into an Excel spreadsheet using ODBC and if they would show some of their code as an example.<BR><BR>Thanks in advance!

  2. #2
    yongxin shi Guest

    Default RE: ODBC insert into Excel?


  3. #3
    Adam Werner Guest

    Default RE: ODBC insert into Excel?

    Many thanks! Creating the System DSN was the key.

Posting Permissions

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