Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 695
  • 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

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

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