Discussion Locked

MS ACCESS 2000 experts?

0 helpful

2 replies

by zander Jul 7, 2002 last reply Feb 3, 2003

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Do you know how to export a text file from Ms Access 2000 and then give the filename todays date? Use this in a macro for daily backup.

Give me your comments and tips.

2 replies

hello mate,
go thru MSAccess help for using
DoCmd.TransferText .. u have everything u need

cheers

Try the following functions in the Filename...

=("c:\export_" & Format(Date(),"mmddyy") & ".txt")

Replace the "c:\export" with a suitable path...

This discussion is closed to new replies.