Access 97 - Automating TransferText not working
Posted on 2001-06-13
Okay, this is rather annoying. I am trying to import data from a text file, fixed field format into my Access 97 database. There are three files - File1.txt, File2.txt, and File3.txt (File3.txt is not always there). I have written a macro that does a TransferText using an import specification (Shiva Import Specification) for File2.txt & File3.txt, which are in the same format. File1.txt is also brought in using a TransferText with an import specification, and it works fine (it is formatted differently).
If I do this by hand using the same specification into the same table(File,Get External data, Import, Select the text file, Advanced, Specs, Shiva Import Specification, and keep clicking Okay) it works fine.
Put the same information into a TransferText line on a macro, and I get this error:
Numeric Field Overflow, Which it associates with a BTrieve table.
Not sure why I'd get the error doing with a macro what I do by hand. I do some screening on it to ensure the file exists (and that is working), but the error is driving me nuts. Any suggestions? Thanks.