I have a fairly simple database (Access2000 Developers Edition) with a table with only six fields. Each month I will receive comma Delimited ASCII text files from around 40 offices to our FTP site. Each file will contain between fifty and two-thousand records.
As it is now, I am manually importing each file manually (one at a time) and running an append query to add the new data to the master table.
Is there any way that I can automate this process? Is there also a way that I can generate a table of those records that were not appended to the master table (if, for example they failed some validation check?)?
Thanks in advance. I am really a novice at this, so I think I need a step by step walk-through on how to do this.
Austin
As it is now, I am manually importing each file manually (one at a time) and running an append query to add the new data to the master table.
Is there any way that I can automate this process? Is there also a way that I can generate a table of those records that were not appended to the master table (if, for example they failed some validation check?)?
Thanks in advance. I am really a novice at this, so I think I need a step by step walk-through on how to do this.
Austin