ok is this possible?
any ideas?
i could be way off
sql = "select new append from " & "'C:\testfile.txt'"

with an ado connection to a foxprotable "NEW"

this has an error "not a table"

thanks

jb