By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,482 Members | 2,451 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,482 IT Pros & Developers. It's quick & easy.

Imported DBF not pulling in all information

P: 80
I have a process whereby I do some data processing outside of Access (in dbase IV format), then link the file back to Access to make some changes, then export the file to text. Recently, for no reason I can see, after I run the process on the dbase file and try to import, I get "Microsoft Access Index information (.inf) file already exists". No matter what option I choose, the linked file does not contain all the information appended to the dbase file during the external process. I can open the same dbase file in Excel and see that the updates to the data have been made, but in Access it's like they don't exist. So I thought, maybe I just need to import the data, rather than linking to the table. Same outcome. The fields that were updated show no data in Access, though the data is there. This is a process that has worked seamlessly for the last six months. What has changed, and how do I change it back?
Feb 7 '08 #1
Share this Question
Share on Google+
1 Reply


cori25
P: 83
In order to help, I need to know alittle more information. If the data is being linked and you see it in the table then the problem has to be in the append query. First off,
1.) I would check to make sure there is no criteria that would eliminate these files from pulling in

2.) Check to see what the table you are linking in has the fields as (text, number,etc) then check to see what the table you are appending to has for these values. (In order to populate the data, they must be the same) Look at the table in design view for this description.

3.) Check the data that you are appending to ensure that there are no duplicates.

Let me know if this helps
Feb 13 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.