Cross updating Excel file and SQL 2000 database
Hell, I read here a one year old post from Nigel Heffernan, about updating a
SQL 2000 table from an Excel spreadsheet through an Access database made with only the Excel file as a linked table. Could you please explain in detail how would I get first the info from the SQL table to the Excel file and than just update one column in Excel that will update a coresponding field in the SQL database. Thank you Richard |
All times are GMT +1. The time now is 01:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com