I currently have a nightly job that reads a csv file and then applies a few equations and imports into a msSQL server express. We we are moving to a Win 7 64 bit computer and having issues with the script.
Below is the connection string we use in 32 bit:
sconnstring= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\xml;Extended Properties=""text;HDR=Yes;FMT=Delimited"""
This is the error we are getting:
"Provider cannot be found. It may not be properly installed"
Access is not installed on this machine.
Thanks in advance for any assistance.