Creating CSV Files

[degsy70]

The thing is, we have developed an Intranet and one of the things it does is allow you to create customised lists. <br>
On the intranet you upload a csv file and it puts the data into your list.<br>
Basically I'm after the easiest way of getting the data from the access subform into a csv file to be able to upload it to the intranet.<br>
if I can get some code that selects all data in the subform and turns it into a csv file that will be great.<br>
<br>
Any ideas<br>
<br>
Help?

 

[DougP]

DoCmd.TransferText will export to a .CSV<br>
<br>
create a command button and add this code to it<br>
<br>
DoCmd.TransferText acExportDelim, , TableName, &quot;C:\Myfile.CSV&quot;, True <br>
<br>

 

[degsy70]

I see what you are trying to do. What I need to know however is whether or not I can use this for a query instead of a table. The data in the form is the result of a query and it is that data that I need to turn into a csv file?

 

[degsy70]

Thanks Pal, I've got it working a treat!