import rows into MYSQL
I have an ACcess frontend to a remote MYSQL. ALso an EXCEL tool that parses text into rows, that we'd like to get these Excel rows now into the MYSQL db.
We figured it would make sense to maybe interface directly with MYSQL from Excel, rather than passing the data to Access, then to MYSQL.
The user signs into the Access front end and authenticates with MYSQL.
Can I link from Excel to this open Access Front end to grab the password? (after storing in variable after the Access front end login)
Or better maybe to have Excel pass the rows to Access, and have Access put them up to MYSQL, as user has already been authenticted in the Access front end?
Subject
Views
Written By
Posted
import rows into MYSQL
255
February 13, 2023 06:33PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.