HI, I have an Excel worksheet I input data into that I’d like to have stored directly into a database. I’d also like to have the data in the database displayed in the same excel worksheet. Currently I am able to connect the database to the Excel worksheet with an ODBC connection, read the data from the database into the Excel worksheet by cycling through the records. Is it possible to have the data I input into Excel also saved into the database. Basically a two-way connection?
I have seen examples of linked Excel worksheets to Access but that is not what I want because then the data is stored in the Excel worksheet, not the database.
