access thread: Visual Fox Pro Import Problem
Message #1 by Miriam Engelberg <MiriamE@c...> on Fri, 7 Sep 2001 14:47:37 -0700|
I'm trying to import data from PeopleWare, which is a Visual Fox Pro-based
database, into Access 2000, but Access gives me an error message "Unexpected
error from external database driver." Suggestions? (The PeopleWare tables
extensions are .dbf)
Thanks in advance!
From: Jie Ray [mailto:lnslz@h...]
Sent: Wednesday, September 05, 2001 3:55 PM
Subject: [access] How to set up the library connection for access
I need to know how to set up the running environment in the VB codes for
the access database.
I usually do this manually by:
and select the libraries in it.
But it is not convenient especially when you install your application to
the other computer, you need to change the reference setting every time.
Is there a shortcut?
Message #2 by Walt Morgan <wmorgan@s...> on Fri, 07 Sep 2001 17:24:14 -0500|
You may want to try opening the .DBF's with EXCEL as an intermediate step,
since they handle xbase files. Of course, you could use VB and DAO/ADO to
read the FoxPro tables. The problem may be too that there are MEMO fields
associated with the DBF's (if memory serves me correctly, they have a DBT
extension and are generally a lot of text in them. That may be where you are
getting bogged down. If you could post the structure of the DBF's I'd be
glad to look at them.