×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

get external data problem with foxpro (dbf) table
2

get external data problem with foxpro (dbf) table

get external data problem with foxpro (dbf) table

(OP)
I have about 30 tables in a Foxpro 9.0 system that I want to import into Access.  These tables have an extension of ".dbf".  Most of the tables imported with no problem using File / Get External Data / Import.  However, with several of the tables, I'm getting the error message "External table is not in the expected format" (error 3274).  I'm able to read these tables  with no problems from the Foxpro environment.   Any ideas on how to get around this would be greatly appreciated.

RE: get external data problem with foxpro (dbf) table

Is this a one shot deal ?

If so, just use FoxPro to export to some common format, like CSV. Then import the tables.

Remember too that FoxPro has that "mark for deletion" record that Access doesn't recognize.

I remember uisng ODBC and thinking to myself "I KNOW I deleted those records, why are they still showing ?"

IIRC, to get rid of them you use Pack.

Tyrone Lumley
SoCalAccessPro
http://www.socalaccesspro.com

RE: get external data problem with foxpro (dbf) table

(OP)
Thanks for the reply Tyrone.  Yes - it's a one shot deal.  I tried the CSV export, but there's a problem with it.  My table has several memo fields, and the export in CSV ignores memo fields.  I used the Foxpro "COPY TO" to do the export.  
Thanks for the info about the deleted records and pack.  I wasn't aware that Access didn't handle that.

RE: get external data problem with foxpro (dbf) table

Also, FoxPro has some native data types that Access doesn't like, that could be your problem...

I seem to recall "skipping" feilds during my inports, and writing VBA code to check the feild type prior to trying to pull it in.

Also. have you tried just setting up and ODBC connection to FoxPro ?

Tyrone Lumley
SoCalAccessPro
http://www.socalaccesspro.com

RE: get external data problem with foxpro (dbf) table

(OP)
I was able to download the ODBC driver use it to import the data.  Thanks Tyrone and Remou.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close