"Joe Duncan" <duncanj@qwest.net> wrote in message
news:ZNKW7.215$WP5.107329@news.uswest.net...
> I have a vba application in Access that tracks patient medication
> dosage information and I need to be able to save the data only
> without the application to a floppy diskette for backup and for
> transfering the files to another computer (the Application is 9 Mb
> the data is less than 200 kb). I am concidering writing my own
> code to open the tables for selected patients then writing the data
> to a comma delimited text file.
>
> But, doesn't Access provide some sort of a way to do this with
> out my having to write my own code? Any help is greatly
> appreciated.
Hi Joe
The method TransferText can be used to export a table or query
to a comma delimited text file. TransferText corresponds to
choosing the export guide in the File-menu.
Public Sub exportTableAsText(strTable As String, _
strPath As String, bolHasFieldName As Boolean)
DoCmd.TransferText acExportDelim, , strTable, strPath _
, bolHasFieldName
End Sub
--
Mikkel Bundgaard
IT University of Copenhagen
http://officehelp.gone.dk
Codito, Ergo Sum