Discussions

Ask a Question
Back to All

Connect to Excel - VBA

Hi, I'm tryying to connect my VBA project to a database.
My VBA code has been already tested by using a local SQL database.

Command I am using is:
"Provider=MSDASQL;Driver={MySQL ODBC 8.0 Unicode Driver};Server=" & DB_ServerName & ":" & DB_Port & ";Database=" & DB_Name & ";user=" & DB_UserID & ";password=" & DB_PW & ";"

Can you please halp me?
Thanks in advance