Re: Import DBF files with MEMO fields

Hi Cindy,
You are so kind to help me so far. I can import the DBF file now, but there
are still many things to do (I mean manually). I've tried to write some VBA
code to do this with just one click but it dumps ... Could you plz write the
sample code to import the DBF, such as C:\db1.DBF to TB1 in msdb.MDB (Form1;
Button1 etc...)
Thank in advance.

"Cindy Winegarden" wrote:

Hi Khoa,

Exactly how are you importing the file? Are you using ODBC data sources
rather than Dbase x? You need access the tables with the FoxPro ODBC and not
with the built-in Jet data engine.

--
Cindy Winegarden MCSD, Microsoft Most Valuable Professional
cindy@xxxxxxxxxxxxxxxxxxx


"Khoa" <Khoa@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:422A570C-B871-464E-AA70-D10F58FE08BE@xxxxxxxxxxxxxxxx
OK. I've tried to download and set it up onto my computer ..., and it
doesn't
work. "External table is not in expected format" is the only thing I
receive
(If the DBF files have at least 1 MEMO field).
Thanks anyway.

"Cindy Winegarden" wrote:

Hi Khoa,

You haven't said which version of the VFPODBC.DLL you have. The latest
FoxPro and Visual FoxPro ODBC drivers work with all versions of FoxPro
tables. What you have will probably work, but why not use the latest
version?

Others in this thread mentioned Dbase III, etc. files. I don't know if
the
FoxPro and Visual FoxPro ODBC drivers support those files.

--
Cindy Winegarden MCSD, Microsoft Most Valuable Professional
cindy@xxxxxxxxxxxxxxxxxxx


"Khoa" <Khoa@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:28158388-95E7-46DD-8CF6-BCCB215DE8A3@xxxxxxxxxxxxxxxx
"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.






.