using macro to export data from access

Hello friends and helpers,
I have a tasking task.
I need to automate the task of migrating data from access 2002 database to sql server db.
I can do this and have done this several times before using sql server's DTS.
However, what is different about this is that the access db that needs to be migrated sits on a user's desk top.
All information I gathered so far points to using access macro to automate the task of exporting this user's data to a text file in a central location and then finally migrating this data to sql server.
Can someone please help me with the steps of using an access macro to automate the exporting of data to a text file.
Once this part is successfully completed, I can take it from there as far as using dts to migrate it to sql server.
The access help menu for using macro to automate this task has not been that helpful.

If there is any links or articles on how to accomplish this, please let me know
Thanks in advance

I agree with your comments but I normally use the upsizing wizard which preserves everything from access rules, contraints to pk and auto numbering.

This case is slightly different in the sense that the client's access db is sitting on his desk top.

So trying to export data using DTS to his access db won't work.

What we are trying to do is use access macro to export data to a text file outside of his desktop and then export data from there to our sql server that is sitting on a remote site.

My problem is understanding the steps in using a macro.

So far, having followed the example from the access help menu is causing an error that says I "cannot update the database because it is a readonly db"

I don't understand this error because:

1, I am not updating the access db and

2, I can write to it.

Any additional help would be greatly appreciated.