How to Use .ini File for TransferText??

[KellyStee]

I'm trying to import a text file using a schema.ini file. Everything works except when I don't specify a specification before the second comma (see below), it uses the default import/export specification. If I put "schema.ini" there, it tells me the file doesn't exists, and if I put the full path and filename there, it takes out the "\" and tells me the file doesn't exist. I even tried using chr(92) and replaced the "\" and that doesn't work either. Any help would be greatly appreciated!!

My code so far is:

DoCmd.TransferText acImportDelim,, "Imported Data", glFileName

 

[KellyStee]

Actually, I figured out the answer to my own question because it was driving me nuts!! ) It seems using a schema.ini file with the TransferText method is a known bug. Instead, Microsoft recommends using SQL:
Db.Execute "SELECT * INTO [Table Name] FROM [TEXT;DATABASE=[Path].[Filename]