Hello
I will have two different tables (with different field structures but with one common field / index)
I need to export the data from these 2 tables into a common text file as below:
First Row (in Text File) = First Row in Table 1
Second Row (in Text File) = First Row in Table 2 (corresponding entry of above)
Third Row (in Text File) = Second Row in Table 1
Fourth Row (in Text File) = Second Row in Table 2 (corresponding entry of above)
Etc..
Between Table 1 and Table 2, 1:n relation is also possible
(1) Is it possible ?
(2) If possible, how should I proceed ?
Also is there any downloadable Help File for MS Access 2000 or 2002 in English ?
(My Machine is German and so is the Help File...)
I will have two different tables (with different field structures but with one common field / index)
I need to export the data from these 2 tables into a common text file as below:
First Row (in Text File) = First Row in Table 1
Second Row (in Text File) = First Row in Table 2 (corresponding entry of above)
Third Row (in Text File) = Second Row in Table 1
Fourth Row (in Text File) = Second Row in Table 2 (corresponding entry of above)
Etc..
Between Table 1 and Table 2, 1:n relation is also possible
(1) Is it possible ?
(2) If possible, how should I proceed ?
Also is there any downloadable Help File for MS Access 2000 or 2002 in English ?
(My Machine is German and so is the Help File...)