kaldrich
asked on
Access 97 - Automating TransferText not working
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Points to JDettman.
amp
community support moderator
amp
community support moderator
thanks!
amp
community support moderator