Open DBF file


A

Anatoly Kurilin

Hi, please help me. I've never done it before. How to to open an DBF file to
read its data?

Thanks in advance.
AK
 
Ad

Advertisements

A

Anatoly Kurilin

Dear Arvin, I did realize. Shoud I use OpenDatabase method or create a
link?
 
A

Al Camp

Anatoly
If your .dbf file data will continue to change in the future, then it's
best to Link the table.
If you are going to convert the .dbf file data into Access and maintain
that data there, then Import.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
A

Anatoly Kurilin

Al, I need to periodically read data from an DBF file which structure is
permanent but its name and path change from reading to reading.
Is it possible to do it without setting a link. For instance, using
OpenDatabase method.
If OpenDatabase is OK, please put some code because I tried and failed.

I don't want to use a link to an DBF file becasue I don't know how to
redirect it. The problem is that the name of an link to an DBF file changes
along with the name of the file.
 
A

Al Camp

Anatoly,
Your missing the point...
If the data in your dbf doesn't change... just the path does... then
Import the data into Access.

Even an OpenDatabase (if that was a legitimate solution) would also fail
(as compared to linking) with the dbf moving all the time.
 
Ad

Advertisements

A

Arvin Meyer [MVP]

If you want to do it in code you can use the OpenDatabase methods and the
Connect property (which is the last argument in the OpenDatabase method).
You will still have the problem of supplying the path each time. I suggest
just using the built in GUI as I described in my first post. It does the
same thing as you would write in code. Linking is probably the better choice
unless the data is unique each time. It that case, you may prefer to import
that data.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 

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

Access and dbf 1
Importing dbf 0
Can an access form write to a dbf file? 9

Top