p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: Visual Fox Pro Import Problem


Message #1 by Miriam Engelberg <MiriamE@c...> on Fri, 7 Sep 2001 14:47:37 -0700
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








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.



Walt








  Return to Index