Hi Everyone,



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!



Miriam Engelberg





-----Original Message-----

From: Jie Ray [mailto:lnslz@h...]

Sent: Wednesday, September 05, 2001 3:55 PM

To: Access

Subject: [access] How to set up the library connection for access





Hi there,

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:

TOOLS/reference....



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?



Thank you!

Jie

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.



Walt