Something like this?:

INSERT INTO tblTransactions(

PO_Number,

Buyer_Initial,

Qty,

Unit_Price,

Software_Description,

AllocationAccount,

PurchaseAccount,

HeatTicketNumber,

PurchaseCostCenter,

PO_Date,

Transaction_Date,

Transaction_Number,

AllocationDate,

AllocatedYN,

EndUserFirstName,

EndUserMiddleName,

EndUserLastName,

LAN_ID,

EndUserLocation,

TermDate,

EmployeeStatus,

Notes,

LicenseAvailable,

Transaction_Type,

AllocationCostCenter,

SoftwareShortName,

PC_Name,

TransferedSoftware,

TransferToFName,

TransferToLName,

TransferToLANID,

OriginalTransactionNumber,

TransferToCostCenter,

CostCenter,

SWstatus,

SWstatusReason,

EmployeeEmail)

SELECT PO_Number,

Buyer_Initial,

Qty,

Unit_Price,

Software_Description,

AllocationAccount,

PurchaseAccount,

HeatTicketNumber,

PurchaseCostCenter,

PO_Date,

Transaction_Date,

Transaction_Number,

AllocationDate,

AllocatedYN,

EndUserFirstName,

EndUserMiddleName,

EndUserLastName,

LAN_ID,

EndUserLocation,

TermDate,

EmployeeStatus,

Notes,

LicenseAvailable,

Transaction_Type,

AllocationCostCenter,

SoftwareShortName,

PC_Name,

TransferedSoftware,

TransferToFName,

TransferToLName,

TransferToLANID,

OriginalTransactionNumber,

TransferToCostCenter,

CostCenter,

SWstatus,

SWstatusReason,

EmployeeEmail

FROM OPENROWSET('MSDASQL',

'Driver={Microsoft Access Text Driver (*.txt, *.csv)};DefaultDir=C:\Users\DCAMPB\Desktop\;',

'SELECT * FROM Master.csv;' )