hi all. here's my problem;. I would like to have a macro to export data from an excel file into the database(SQL) for insert and update data purposes. but i'm not sure how to do this.Can someone please show me a code syntax on how to do it?the excel file name is FISTdb.xls and the table i want to get it updated is company_info.how can i ensure the data update the right firld in the database? thanks all. :) ur help is much appreciated.
*i'm not sure where to post this. mod, please move the thread if necessary. thanks.