 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / October 2005Open DBF file
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 With the database open: File Get External Data Import (or Link) Change the Files of Type dropdown to 1 of the DBF filetypes  SignatureArvin Meyer, MCP, MVP Microsoft Access Free Access downloads: http://www.datastrat.com http://www.mvps.org/access > 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 Dear Arvin, I did realize. Shoud I use OpenDatabase method or create a link? > With the database open: > [quoted text clipped - 9 lines] >> Thanks in advance. >> AK 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. Signaturehth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions > Dear Arvin, I did realize. Shoud I use OpenDatabase method or create a > link? [quoted text clipped - 13 lines] >>> Thanks in advance. >>> AK 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. > Anatoly > If your .dbf file data will continue to change in the future, then it's [quoted text clipped - 18 lines] >>>> Thanks in advance. >>>> AK 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. Signaturehth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions > 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. [quoted text clipped - 28 lines] >>>>> Thanks in advance. >>>>> AK 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. SignatureArvin Meyer, MCP, MVP Microsoft Access Free Access downloads: http://www.datastrat.com http://www.mvps.org/access > 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. [quoted text clipped - 28 lines] > >>>> Thanks in advance. > >>>> AK |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.