Error 3274 External File Not In Expected Format

Alisa

Registered User.
Local time
Today, 01:36
Joined
Jun 8, 2007
Messages
1,931
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?
 
Moniker, thank you for your response. I get the same error opening them in excel - although someone else is able to open them in excel but not in access. The explanation doesn't make sense to me because I have several dozen of these files, all created and currently in use by an existing program, and most of them import with no problem. If the issue was SP3 wouldn't ALL of the tables fail to import? Alternatively, it the issue really IS SP3, is it possible to revert to SP2? I need to be able to automatically import all of these tables for at least the next 3 to 6 months until we are done transitioning from the old program, so having someone manually open them in excel is not a preferable solution. Any other ideas?
 

Users who are viewing this thread

Back
Top Bottom