Saved Export in Access 2000

K

Keith

I have am mdb file that has a number of saved exports defined. Although I am
working in Access 2007, I continue to save it as an Access 2000 database
since most of the other users run Office 2000.

I recently discovered the RunSavedImportExport method, which works great.
Unfortunately, it doesn't work when the database is opened using Access 2000.
I tried recreating the code using the transfertext method, but I cannot
figure out how to create a tab delimited file this way.

So my question is this: Is there a way to programatically run a saved
export in Access 2000? If not, is there a way to programatically export the
data from a query to a tab delimited file?

Thanks,

Keith
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top