Code:
DoCmd.TransferDatabase acImport, "Paradox 5.x", _
ImportDir, , oFile.Name, Left(oFile.Name, Len(oFile.Name) - 3)
I am importing a few dozen paradox tables from a folder (ImportDir). This code works most of the time, but on a few of the tables I get error 3274. I can't find any documentation on this. I found a few previous posts, but they are from people who are importing from FoxPro, not Paradox. I have the newest version of JET so I don't think that is the problem. I also get the same error if I just manually do File>Get External Data>Import on the same tables that generate the error in the code. I had some other people test it and even though we are all on XP/Access 2003/SP3, some get the error and others don't. When viewed in excel there is nothing abnormal about the data in the tables that cause the error, and like I said, some people can import it with no problems. What could be causing this error?