on 06-09-2010 12:57 AM
Hi
using crystalreports 2008 i try to open a dbf file (DBASE IV)
creating a connection in ACCESS/Excel (DAO)
i select the file, it opens the connection but when i try to selevct the table i receive the following
error code: DAO error code: 0Xcca
Description: External table is not in the expected format.
Someone any ideas?
Regards
rubenc
What do these 2 lines have in common?
using crystalreports 2008 i try to open a dbf file (DBASE IV)
creating a connection in ACCESS/Excel (DAO)
What are the steps and which driver are you selecting in the Database wizard?
Thank you
Don
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ruben,
I tested it using one of our old DBF sample files and it works for me. I also download your viewer and I see the same.
Is there another PC where it does work? Could be the version of MDAC you have installed.
Other than this all I can suggest is you purchase a support case and have a Rep work with you directly, you can send your sample DBF file for testing.
You can purchase a case from this link:
Try creating an ODBC DSN to your DBF file and see if that works in CR.
Thanks again
Don
This problem may be solved owing to <a href="http://www.recoverydbf.com">dbf recovery</a>. It owns all necessary features for recovering data after various issues: power failures, viruses, hacker attacks. The utility has easy to use and simply interface due to every experienced users.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I received a notification of a reply from Don:
Ruben Carreon, You are watching the thread "crystalreports open dbf file error", which was updated on Jun 9, 2010 4:45:09 PM by Don Williams. Subject: Re: crystalreports open dbf file errorMessage: What do these 2 lines have in common? using crystalreports 2008 i try to open a dbf file (DBASE IV)creating a connection in ACCESS/Excel (DAO) What are the steps and which driver are you selecting in the Database wizard? Thank you Don
but i dont see the reply here in my thread, but anyway i will try to answer it
Steps to connect :
1) Open the Database Wizard
2) New Connection
3) Access/Excel(DAO)
4) Select the database file: D:\ADMINSAB\MGW10008.DBF
5) Select Type: i tried with dBase III, IV, 5.0
it opens the connection and gives me the list of dbf files (tables) that i have in that folder.
so far so good
when i try to select the table i want, inthis case MGW10008.DBF
i receive the error i mentioned:
error code: DAO error code: 0Xcca
Description: External table is not in the expected format.
Thank you Don for your help
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.