Hi,
you can use schema.ini but, not with docmd.transfertext. You can use following code instead.
Set cn = CreateObject("ADODB.Connection")
Set cn = CurrentProject.Connection
ssql = "select top 1 * into "
ssql = ssql & "[text;database=" & OutputFolder &...