none
error importing dbase III datatable to access. RRS feed

  • Question

  • I have an dbase III database which users import into access 2007 in order to create reports. It was importing fine until now, and suddenly just one datatable stopped importing and it now gives this error:

    Cannot open database. It may not be a database that your application recognizes or the file may be corrupt.

    How can this be fixed?


    Debra has a question

    Friday, September 18, 2015 2:52 PM

Answers

  • To export the dBase datatable as text you will need the software or ask the person who created the database to do it for you. And, yes, you can import a text file into an Access database. In fact, as I said, importing the text file should isolate any bad rows and put them into an Import errors table.

    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals


    Friday, September 18, 2015 4:51 PM

All replies

  • I would export the database as a text file. If it isn't too big try visually scanning it to see if you spot a problem. If that isn't practical, import the new text file into Access and see if that creates an import error table. The import error table will tell you which lines failed to import and why.


    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Friday, September 18, 2015 3:08 PM
  • How would I change it to a text file? Will I still be able to import it to access like that?

    Debra has a question


    Friday, September 18, 2015 3:19 PM
  • To export the dBase datatable as text you will need the software or ask the person who created the database to do it for you. And, yes, you can import a text file into an Access database. In fact, as I said, importing the text file should isolate any bad rows and put them into an Import errors table.

    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals


    Friday, September 18, 2015 4:51 PM