Access to Text File - Export (1 Viewer)

[manianz]

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

 

[ddmcn]

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

What you are constructing is a report...have you designed the report yet? Are you basing the report on a query?

 

[manianz]

What you are constructing is a report...have you designed the report yet? Are you basing the report on a query?

Hello

Thank you very much for the immediate response
My basic requirement is to create the data in Access and export the same as Text file. Correctly formatted text file is my requirement

(1) Is it possible by writing a Query / Report ?

Any help on the Help Files in English ? since I need to learn the basics and my Help File is in German

Regards

 

[___]

For a query...

DoCmd.OutputTo acOutputQuery, "YourQuery", "MS-DOSText(*.txt)", "C:\YourFile.txt", False

in the OnClick event of a button, or...

DoCmd.OutputTo acOutputReport , "YourReport", "MS-DOSText(*.txt)", "C:\YourFile.txt", False

for a report

HTH

 

[___]

Output formats are...

HTML (*.html), Microsoft Active Server Pages (*.asp), Microsoft Excel (*.xls), Microsoft IIS (*.htx, *.idc), MS-DOS Text (*.txt), Rich Text Format (*.rtf), or Microsoft Data Access Page (*.html)