extremely dirty Powershell script to read data from a free-tables DBF

dbf_reader.ps1

# this is a quick and dirty proof-of-concept of reading our specific DBF files from Powershell
# WARNINGS: 
# 1. you have to have the foxpro OLE DB 32-bit version installed  
# 2. you have to run this w/ the 32-bit version of powershell
# 3. 'exclusive=no' may not be right for you
# 4. 👏 DONT 👏 USE 👏 FOXPRO 👏 ANYMORE 👏
# I don't know what Powershell will do will all those emojis and I'm not going to find out

$ConnString = "Provider=vfpoledb;Data Source=h:\;Extended Properties=dBASE IV;exclusive=no"
$Conn = new-object System.Data.OleDb.OleDbConnection($ConnString)
$Conn.open()

$cmd = new-object System.Data.OleDb.OleDbCommand("select * from errorlog2 where day(date)=day(datetime()) and month(date)=month(datetime()) and year(date)=year(datetime())",$Conn)
$da = new-object System.Data.OleDb.OleDbDataAdapter($cmd)
$dt = new-object System.Data.dataTable
$da.fill($dt)
$dt|select date, message