MySQL Forums
Forum List  »  Microsoft Access

import rows into MYSQL
Posted by: dave wilson
Date: February 13, 2023 06:33PM

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?

Options: ReplyQuote

Written By
import rows into MYSQL
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.