How to work with .dbf file created by GIS

[cowboy]

Trying to get some information from a .dbf file that comes from GIS I tried several things and came up blank, does anyone have any experience with this? I tried opening up this file with access and it says "The Microsoft Access database engine could not find the object 'CABZ_Lines.dbf'." so GIS uses a different format. I can open it in excel, not sure if that helps in any way.
Thanks for help.

[RuralGuy]

Have you tried "importing" the .dbf file?

[cowboy]

I tried
DoCmd.TransferDatabase acImport, "dBase IV", "C:\Desktop\Junk\", acTable, "CABZ_Lines", "newTable"
It gives me a runtime error '3011' The M A database engine could not find the object 'CABZ_Lines'.
Now I tried opening a random excel file in 2003 and did a save as and saved in dbf IV format and used the same line of code and it worked. I then opened up the file GIS created "CABZ_Lines" in excel, did a save as and saved in dbf IV format and it failed again, which really confuses me.

Thanks for taking a look at this.

[cowboy]

Here is a jpg of the 2 files
Top: Random personal file that code worked on (note: file did not have more than 9 columns, the rest were added by excel when saved as dbf)
Bottom: GIS file that code did not work, similar format to the file on top

[RuralGuy]

I tried
DoCmd.TransferDatabase acImport, "dBase IV", "C:\Desktop\Junk\", acTable, "CABZ_Lines", "newTable"
It gives me a runtime error '3011' The M A database engine could not find the object 'CABZ_Lines'.
Now I tried opening a random excel file in 2003 and did a save as and saved in dbf IV format and used the same line of code and it worked. I then opened up the file GIS created "CABZ_Lines" in excel, did a save as and saved in dbf IV format and it failed again, which really confuses me.

Thanks for taking a look at this.

I'm pretty sure you need to specify the .EXT when you call out the file to import.

[cowboy]

I tried it with and without the .EXT and it seemed to work the same.

[RuralGuy]

Is this a recurring project or a one shot deal? Have you tried using the wizard for the import?

[cowboy]

What my overall design is, I have a Access database that has a list of all the line names in a project. Those lines are to be entered in a GIS mapping program and displayed. The project is going to take about a year so I wanted to write a function that checks to make sure the names that are listed in the Access database and the GIS are the same.
Where would I find the import wizard in Access 2010?

Another thing I tried that did not work for me was to try to assign the file as an ADODB object and open it as a recordset.

[RuralGuy]

Where would I find the import wizard in Access 2010?

External Data>More...