Dave Sharpe
davesharpe2 at cox.net
Fri Feb 27 18:52:32 CST 2004
John I know nothing about Paradox but, I found the following VB6 code that might help. http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=47621&lngWId=1 Using ADO & ADOX, convert between various database formats like Text, Access, Excel, dBASE, Paradox & HTML. This is a NEW VERSION of Any-to-Any Database converter. Can You compile ? If not, and You're interested in trying; I can compile and send to you. Dave ----- Original Message ----- From: "John W. Colby" <jwcolby at colbyconsulting.com> To: "AccessD" <AccessD at databaseadvisors.com> Sent: Friday, February 27, 2004 6:27 PM Subject: [AccessD] Importing (or linking to) Paradox files My client sent me an email 3 weeks ago with three Paradox .db files attached. I was able to successfully link to 2 of those 3 files, but the third says "file not the expected format". The client just sent me 60 of these files which I need to import into Access. ALL of them now say "not the expected format", including the same file names of the two that previously imported. My question is are there versions of paradox files that Access can understand these but not those? Are there various drivers that need to be downloaded or something? The client says that he installed a SP for Paradox 11 in the last 3 weeks. Could that have screwed around with the files and made them into a format that Access no longer understands? To make things even Murkier, he claims that he can open them just fine there. Hmmmm. John W. Colby www.ColbyConsulting.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com