Import dbf file

[MechEngr]

I am trying to import a dbf file into my Access DB using the following:

DoCmd.TransferDatabase acImport, "dBase 5.0", "C:\temp\member.dbf"

I get an error message indicating that the path is not valid. The file
exists exactly as specified and I can import the file manually. Any ideas?

Your help is appreciated in advance.

 

[Alex Dybenko]

Hi,
the syntax is bit tricky in DBF files case, try:

DoCmd.TransferDatabase acImport, "dBase 5.0", "C:\temp", acTable, "member",
"member"

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[MechEngr]

Thank you very much Alex. That was exactly what was needed.

Another question (off topic)... can you recommend a good reference manual
that will provide this kind of answers to my questions? I find that most of
the good questions I have can (have been) answered here.

Thanks again

 

[Cindy Winegarden]

Hi !

I think you'll find that reference manuals don't cover things like the
question you asked. For the best "reference manual" go to
http://groups.google.com and put some relevant keywords in the search box.
Also, there's an advanced search where you can specify a time period and
range of newsgroups such as microsoft.public.access.* .

Google Groups has been a great source of information for me when I'm working
with technology that is outside my area of expertise (Visual FoxPro).

 

[Alex Dybenko]

Thanks Cindy,
fully agree with you


--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com