Can anyone help me understand why I am getting an error? I am trying to get my data from Excel to store in Access and my connection is not working. I am running office 365 and I want to have the files on my OneDrive. I started this on my desktop that is why my transit file I pointing to the desktop.
runtime error 3706. Provider cannot be found it may not be properly installed
Dim mtransit_file As String
mtransit_file = "Provider=Microsoft.jet.OLEDB.4.0;Data Source=c:\desktop\QuoteS1.mdb"
mConnection.Open mtransit_file
I have also tried ACE.12.oledb and I am still getting errors.
Any assistance will be greatly appreciated.
runtime error 3706. Provider cannot be found it may not be properly installed
Dim mtransit_file As String
mtransit_file = "Provider=Microsoft.jet.OLEDB.4.0;Data Source=c:\desktop\QuoteS1.mdb"
mConnection.Open mtransit_file
I have also tried ACE.12.oledb and I am still getting errors.
Any assistance will be greatly appreciated.