ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Cross updating Excel file and SQL 2000 database (https://www.excelbanter.com/excel-programming/298499-cross-updating-excel-file-sql-2000-database.html)

Richard Ponti

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