Form to Csv

[Kgangani]

I have a form that users can input information in. I want to export this information as a .csv


and have another software read it in. Can I create a csv right away, or does it need to covert to Excel first and then make it a csv?

[aytee111]

You need to export the data as text and name the file ".csv". The data must be on a table which you can export or you can export from a query. A button on a form can either run a macro or a VBA routine which does the TransferText command. It uses a specification which you need to create first.