Read Text file into Table - Access 1707

[PoodleBytes]

That is great! I can't tell you how much I appreciate it!

But honestly anything you have is going to be lightyears better than what I could have done with much more work!

Not sure this is a help - but for the first field I use this code (in Excel):
Function SplitCaps(strIn As String) As String
Dim objRegex As Object
Set objRegex = CreateObject("vbscript.regexp")
With objRegex
.Global = True
.Pattern = "([a-z])([a-z])([ ])([A-Z]([A-Z]|[ ]))"
SplitCaps = .Replace(strIn, "$1$2~$4$5")
End With
End Function