Import DBF files with MEMO fields

[Khoa]

I'm using MS Access 2002. I have to import data from DBF files everyday.
Every DBF files which has no MEMO fields will be imported succesfully, but
that won't happen for those DBF files which have a MEMO field. (In the past,
when I used MS Access 97, it's OK for all DBF files). To solve this, I have
to copy the DBF files that have MEMO field to other DBF files which have no
MEMO field, then import that files to Access.
Is there any other mean to import those DBF files to Access directly ?

 

[Cindy Winegarden]

Hi Khoa,

Use the FoxPro and Visual FoxPro ODBC drivers, downloadable from
msdn.microsoft.com/vfoxpro/downloads/updates/odbc .

 

[Joel]

Hi Cindy,

I am having the same issue,but the DBF files are in DBase III/IV format, and
are not FoxPro/Visual Fox Pro.

The issue I am having is with DBase III/IV files with Memo fields.

Joel

 

[Charles E. Vopicka]

i could be wrong but i think the point was that FoxPro uses dbase files
natively and therefore the drivers would support all data types that
FoxPro / DBF files have. since there are multiple drivers for ODBC one
should support full DBF format

Hi Cindy,

I am having the same issue,but the DBF files are in DBase III/IV format, and
are not FoxPro/Visual Fox Pro.

The issue I am having is with DBase III/IV files with Memo fields.

Joel

--
Charles E. Vopicka's (Chuck) : (e-mail address removed)

Database Management, GIS Specialist and Research Assistant

Forest Biometrics Research Institute
University of Montana - College of Forestry and Conservation
Missoula, MT 59812
United States of America

Phone:
(406)243-4526
(406)243-4264
(406)549-0647 (Home)

HAVE A NICE DAY (-:

"UNLESS" (The Lorax, by Dr. Seuss)

 

[Khoa]

"You can find out whether you already have the Visual FoxPro ODBC Driver
installed by checking to see if a file called VFPODBC.DLL exists in your
Windows System directory." - And I found that file in C:\Windows\System32
Directory - That means I don't have to download/install FoxPro and/or Visual
FoxPro ODBC drivers ?
The DBF files are created by Foxpro 2.6 for Dos.