I have 2 TEXT files of data. Both are comma delimited, files. They IMPORT into an Access Table just FINE. HOWEVER. I need to import the SECOND data file as addtional FIELDS (columns) of an EXISTING database. When I IMPORT the data file into an existing table now....it adds the data to the END of the database (appends it) as additional records. I NEED to import that data as additional FIELDS. Example: I have an existing table of 5000 records with 10 fields. I have a text file with 5000 entries of 4 data items each. I need to import that text file into the Existing 5000 record table so that the table will afterwards still have 5000 records but 14 fields. Currently, when I important data from that text file into the existing table....I end up with 10,0000 records. Any advice GREATLY appreciated. THANKS !

Add you four fields to you existing table. Create a temporary table to hold your second dataset. Import you data into the temp table. Then write an update query to update the original table with the information stored in the temp table. Match records using the common key.