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
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