import dbase table

R

Richard

Hi

How do I import a .dbf FoxPro table via code?

i tried using this code but couldn't work with error msg, "External table is
not in the expected format"

docmd.TransferDatabase acImport,"dbase IV","\\server\common\postal
beat",acTable,"type.dbf"

Thanks in advance
Richard
 
W

wei zhong hua

Richard said:
Hi

How do I import a .dbf FoxPro table via code?

i tried using this code but couldn't work with error msg, "External table is
not in the expected format"

docmd.TransferDatabase acImport,"dbase IV","\\server\common\postal
beat",acTable,"type.dbf"

Thanks in advance
Richard
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DoCmd.TransferDatabase acImport - an Excel DBF 2
Export an Access Table as an dbase III file 8
TransferSpreadsheet vs. TransferDatabase 6
cannot link Foxpro file as table, access2000 3
import .dbf file 4
Import dbf with VBA 3
TransferDatabase to a variable name 6
Microsoft Jet database engine could not find the object 'CRCT2006' 2

Top