Exporting to a text file

[Joe Williams]

I would like to be able to export data from a table to a text file. The file
would be plain comma separated, one record, one line text file. The user
should have the ability to select a save location and alter the name.

Alternatively, I need some code to be able to read this same line of
information in from that file.

Any pointers on where to start with this code?

Thanks

Joe

 

[Ken Snell [MVP]]

Check out TransferText in VBA Help for how to use it for export and import.

See The ACCESS Web for how to use the API function call to get the Browse
window to show so that a filename can be selected:
http://www.mvps.org/access/api/api0001.htm