#!C:/strawberry/perl/bin/perl.exe

use strict;

use DBI;
use Text::CSV;
use Win32::OLE;

my $DBFile = "KosJourney.accdb";
my $DBHandle = DBI->connect("dbi:ADO:Provider=Microsoft.ACE.OLEDB.12.0;Data Source=$DBFile;Persist Security Info=False;") or die $DBI::errstr;

.....

open my $FILEHANDLE,$FilePath or die "Failure opening CSV file for reading: " . $!;
while (<$FILEHANDLE>)
{
	chomp;
	next if /Last Name/;
	my ($LastName,$FirstName,$GUID) = split (/\t/,$_);
	$LastName =~ s/"//g;
	$FirstName =~ s/"//g;
	$GUID =~ s/"//g;
	my $FullName = $FirstName . " " . $LastName;
	
	my $InsertUserQuery = "INSERT INTO Users (Username,FullName,FirstName,LastName) VALUES (?,?,?,?);";
	
	&Echo("Executing SQL: " . $InsertUserQuery);
	
	my $InsertUserResult = $DBHandle->prepare($InsertUserQuery);
	$InsertUserResult->execute($GUID,$FullName,$FirstName,$LastName);
}
close $FILEHANDLE;

##</code><code>##

DBI connect('Provider=Microsoft.ACE.OLEDB.12.0;Data Source=KosJourney.accdb;Persist Security Info=False;','',...) failed: Can't Open Connection 'Provider=Microsoft.ACE.OLEDB.12.0;Data Source=KosJourney.accdb;Persist Security Info=False;'

Package    : DBD::ADO::dr
Filename   : C:/strawberry/perl/vendor/lib/DBD/ADO.pm
Line       : 158
Last error : -2146824582

OLE exception from "ADODB.Connection":

Provider cannot be found. It may not be properly installed.

Win32::OLE(0.1709) error 0x800a0e7a
in METHOD/PROPERTYGET "Open" at PopulateUsersFromResultCSV.pl line 21
Can't Open Connection 'Provider=Microsoft.ACE.OLEDB.12.0;Data Source=KosJourney.accdb;Persist Security Info=False;'