Generating a file

  • Thread starter Thread starter JB_96RS
  • Start date Start date
J

JB_96RS

Hello! I am trying to have Access create a *.csv file for me based upon
a form. Not sure how to go about this. I have the form made with the
fields that I want to be included in the csv file, but I am not sure
how to get the data out into a file.

Thanks,

JB
 
A form is not a data export source! You can export files
from a table, or, if you don't want all the records /
fields, from a query. Select your table or query on the
database window, go to menu File > Export, select file
type "Text Files" and follow the wizard. This will export
the file once, but it will also save an export
specification wich you can use to repeat/automate the
export through a macro (action TransferText) or VB code.

HTH,
Nikos
 
Back
Top