Posted on 2011-04-26
I want to figure out what the specifications of "Specification BJU" included in this line of code. Where do I find this?
DoCmd.TransferText acImportFixed, "Specification BJU", tempTable, strPathNoExt & ".txt", yes
When I look in the help it indicates that the argument is called a "SpecificationName" Help mentions this:
A string expression that's the name of an import or export specification you've created and saved in the current database. For a fixed-width text file, you must either specify an argument or use a schema.ini file, which must be stored in the same folder as the imported, linked, or exported text file. To create a schema file, you can use the text import/export wizard to create the file. For delimited text files and Microsoft Word mail merge data files, you can leave this argument blank to select the default import/export specifications.
Any idea where I'd start looking for "Specification BJU"? Is it a seperate file? Is it a setting in Access itself? HELP!