how do i create a file in access

[205210864]

how do i create a file by a click of a button on an access form. the file i need to create is a text file with a heading and column names.

[Rabbit]

Are you just trying to export data to a text file?

[205210864]

i have a database poulated with data.need to generate a text file that has a heading,column headings and data from my tables.

data must witten at particular x,y co-ordinates in the text file.

please inform me : - how to create a text file by a click of a button
(file must include headings).

- how to write to a file at specific co-ordinates

[MMcCarthy]

i have a database poulated with data.need to generate a text file that has a heading,column headings and data from my tables.

data must witten at particular x,y co-ordinates in the text file.

please inform me : - how to create a text file by a click of a button
(file must include headings).

- how to write to a file at specific co-ordinates

If you are talking about a fixed length text file. Where each field is given a specific number of characters and spaced accoringly.

Then export the data and select the txt file type in the save as dialog box.
A wizard should open to guide you through the export.

[205210864]

If you are talking about a fixed length text file. Where each field is given a specific number of characters and spaced accoringly.

Then export the data and select the txt file type in the save as dialog box.
A wizard should open to guide you through the export.

i tried exporting and the wizard poped up,but how do i tell the file i want to write the heading on row 2 starting at column 3.

also is there any way to create a macro which records the exporting of table data into a text file,if show please let me knw how.

[ADezii]

i tried exporting and the wizard poped up,but how do i tell the file i want to write the heading on row 2 starting at column 3.

also is there any way to create a macro which records the exporting of table data into a text file,if show please let me knw how.

Check the Print # and Write # Statements. They may be what you are looking for.