attaching text files to defined tables in access

[locutus]

HI !

I want to know if it is possible to attach / link two files to a table.

Here is my code at the moment:

Set tdf = reeldata_db.CreateTableDef("qcstore")
tdf.Connect = "text;database=c:\reeldata_project\;"
tdf.SourceTableName = "qcdata.txt"
reeldata_db.TableDefs.Delete ("qcstore")
reeldata_db.TableDefs.Append tdf



the table is called qcstore and is set up in the DB already.
I am currently adding the file qcdata.txt to this table but now have had a request to add a second file called L53qcdata.txt to this table as well. Can I add two files at the same time ?
I tried this but it didn't work:
tdf.SourceTableName = "qcdata.txt" & "l53qcdata.txt"
but it crashed out and didn't like it. The txtfiles are all in the same directory.

Any help would be great.
Locutus

[Steven McGarva]

Could you not simply call it twice as shown below?

Set tdf = reeldata_db.CreateTableDef("qcstore") 
tdf.Connect = "text;database=c:\reeldata_project\;" 
tdf.SourceTableName = "qcdata.txt" 
reeldata_db.TableDefs.Delete ("qcstore") 
reeldata_db.TableDefs.Append tdf 

tdf.SourceTableName = "L53qcdata.txt " 
reeldata_db.TableDefs.Append tdf

or merge the two files first.........