ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Import External Data: Saving changes to the database (https://www.excelbanter.com/excel-discussion-misc-queries/138076-import-external-data-saving-changes-database.html)

Jean

Import External Data: Saving changes to the database
 
Hello,
Is there a way to save changes made in excel to the database table after
importing thru the Import External Data ?
Thanks, Jean

Andrea

Import External Data: Saving changes to the database
 
Hi Jean,
you need vba code and of course the permission to modify the original
database. One book very much usefull is:

Managing Data with Excel
By: Carlberg, Conrad
Published By: Pearson Education

Clear and simple
Andrea
"Jean" wrote:

Hello,
Is there a way to save changes made in excel to the database table after
importing thru the Import External Data ?
Thanks, Jean



All times are GMT +1. The time now is 08:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com