Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Posts
    1

    Unanswered: importing data from excel to SQL server real time

    hi,

    how can i take data from an Excel spread sheet and populate
    a SQL-server database . I have 4-5 spread sheets which are
    constantly updated real time. All updates,deletes,inserts in Excel
    must be reflected in SQL server concurrently.

    thanks
    apar

  2. #2
    Join Date
    May 2002
    Posts
    299
    The equivalent of SQL Server trigger in Excel can be handled with Worksheet_Change() event. So, write your vba to connect to SQL Server and update the changes.
    --
    -oj
    http://www.rac4sql.net

Posting Permissions

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