Automatically import ASCII text?

[ausmoran]

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. 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

 

[Rich_Lovina]

First, there are many postings on this under UserName Randomblink, in GENERAL.

Second, if some records do not append, you need to discover why. Most common reason is that your TO table has a Dbase definition item ALLOW ZERO LENGTH. This is set at a default of NO. Change it to YES. Also make doubly sure that field lengths are the same in both tables and that Formats are the same.