Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 701
  • Last Modified:

How do I imporot QA database data files into Access?

Hello,

I am doing a program conversion from a QA database (very very old program) to access 2003.

The data files have an dbf extension but none of the dbf files in access allow it to be imported. I can't even use odbc to connect to it.

Is there any way to import these files??

Thank you,

Joe
0
linder76
Asked:
linder76
1 Solution
 
linder76Author Commented:
I forgot to mention I keep recieving the message:

"External table in not in the expected format"

0
 
jrb1Commented:
Hi hologos2357,

Looking up the files created by this (it's Q&A Database by Symantec), the file format should be compatible with dBase 3 and 4.

Regards,
John
0
 
rockiroadsCommented:
Does your QA Database allow export of data files into CSV/Text format?
If so then u can use that to import into Access
0
 
csachdevaCommented:
Ask you users to open up the excel file and manually "Save As" to XLS format.  The exported excel is in HTML format, this is evident if you open it up in a text editor, all nice HTMLs.  But "real" excel files are all hex/binary, so you must ask your users to manually "Save As" Excel format after they edit.

I think that is a small price to pay for having the functionality.

regards,
Chetan Sachdeva
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now