I am new to SQL and would like some help on this issue. I have added a table to my SQL 2000 database and manually imported the data from an Excel spreadsheet into it. Whenever the data changes on the spreadsheet, I would like to be able to update this table from a job I would execute at my PC through an ODBC connection. Is this possible? If not, can you suggest a way to perform this update? Thanks much.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Update a table from a remote PC using data in Excel
- Thread starter JazzyLee
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question