How can I update data in a linked text file with Access 2013
Posted on 2013-11-06
What is an alternative file format to dbf? Access 2013 no longer supports dbf files. I am looking for an alternative format, other than Access tables. We like the data to be external to Access, this way we can link to over 100 tables without blowing out the 2 GB max size of a database. I tried .txt and .csv, but the problem is we cannot update data within the files using Access. We can append records, but updates and deletes are not allowed. I know we can maintain updateable tables in Access then export to txt for reporting, but I just wonder if there is another way.