[AccessD] Import from FoxPro

I have had to through Excel sometimes for FP Tables.

Check your properties after importing to Access

Joe Hecht
Los Angeles CA

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hollis,Virginia
Sent: Friday, June 24, 2005 4:40 AM
To: accessD at databaseadvisors.com
Subject: [AccessD] Import from FoxPro

Ok, what is the secret to importing from FoxPro to Access 2003? It is
not in the list of types anymore. I looked through the KB articles but
still have problems.

 

I pulled the tables up in Visual FoxPro, saved them out as dBase IV
files, and then tried to import them into Access 2003.  I got the
message:

 

"Unexpected Error from External Database Driver (8961)"

 

I was able to create an ODBC datasource based on a FoxPro driver that
was already on my computer.  I tried to import the tables, and it looked
like it was going to do it, but then I got an error, "Decimal field
precision too small...

 

I'm running out of ideas.

 

Virginia

 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com