Open DBF file

[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

 

[Arvin Meyer [MVP]]

With the database open:

File
Get External Data
Import (or Link)

Change the Files of Type dropdown to 1 of the DBF filetypes
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Anatoly Kurilin]

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

 

[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

 

[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.

 

[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.

 

[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