ChicagoPete,

I ran across this article. It discusses how to manually read in text files
in Access using VBA. Here is the link to it:

http://www.applecore99.com/gen/gen029.asp#open

You could write you own conversion program. Read it in from a text file and
then build your Access rows into the separate tables as you go.

You can also automatically fix the data as you go (set Null to "").

Plus you can display record progress information so you can see if your
program hangs up.



Good luck.

Dennis