Hi,
I have a one off task that I'm trying to do which is sendng me round the bend.
Background: Had 2,700 "dbf" files in a directory which I have extracted 1 table from each file into Access 2 (which has been converted into Access97). Each table has the same name (CustomerDetails) but has a numeric figure (from 1 - 2700) tagged on the end (ie CustomerDetails1). Each table has the same field names.
Issue: What I'm trying to achieve is to combine each of the 2700 tables (which has 1 row, 5 columns of data) into one master Access97 table.
Does anyone have any suggestions on how I can do this?
Many Thanks
Adam X-)
I have a one off task that I'm trying to do which is sendng me round the bend.
Background: Had 2,700 "dbf" files in a directory which I have extracted 1 table from each file into Access 2 (which has been converted into Access97). Each table has the same name (CustomerDetails) but has a numeric figure (from 1 - 2700) tagged on the end (ie CustomerDetails1). Each table has the same field names.
Issue: What I'm trying to achieve is to combine each of the 2700 tables (which has 1 row, 5 columns of data) into one master Access97 table.
Does anyone have any suggestions on how I can do this?
Many Thanks
Adam X-)