I have a database that pulls in .txt files and appends them all to a table. I used an import specification, called by a module, to accomplish this. The database works perfectly until I split it. Once split, I am getting a "3349 - Numeric Overflow" error.
I understand this has to do with the data types. Originally, I was pulling the data in as text, date/time, and currency. I've since tried a few different combinations (replacing currency with long, replacing text wtih memo, etc) with no luck. What is most frustrating is that this functions correctly until I split the DB.
I have confirmed that the data types are the same between the import spec and the destination table. What else should I look for? I've attached an image that shows the text file, most of the import spec, and the design view of the destination table.