Linking an access table to a DBF file

[accessaspire219]

Hi,
I have an access table which is empty, I need to link it to a DBF file which contains the data that should be in the table. The reason why I need to link is because the DBF file is updated every week and so I would want my table to be updated too. And the reason why I need the table is because I need to calculate a field which I need to join to in aquery - which I cannot do if I directly link the query to the DBF file - hence I am building this table as a interface between the query and DBF file which will calculate the field I need in the query.
Thanks.

 

[Atomic Shrimp]

You could set up some kind of scheduled event to copy the table into your own empty (presuimably extended) structure, but I think that's more work than is necessary.

How about:

--Link the dbf table so Access can see it

--Create a query using the linked dbf. Add some calculated fields in the query (NB: these are just calculations that will show in the query results, not write back to the table)

--Treat that query as if it were a table, in your further queries where you need to link to the calculated bits.

 

[PaulO]

I have been struggling to link external DBF files to Access2007 database ... keep getting message something like "linked table not in expected format" ... ?

Can't Access read DBF files?

 

[JANR]

Well yes access can link to DBF if it is a DBF1, dbf2,dbf3 files, dbf4 and newer usually dosen't work. I have the same problem with some of my linking attempts to an application.

My workaround have been to use excel to convert these into either txt or xls files which I can link easilly.

I would think you can link via ODBC, but I haven't gotten there yet myself.

JR