trouble exporting table to text file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using a macro to transfer a table to a text file. I get the message 'The
Microsoft Jet database enging could not find the object 'file.txt'. In
another database I have no problem.
 
Hi Rick,

There are quite a few possible reasons for getting this message. One is
described at http://support.microsoft.com/?id=208544. ALso,

-If you're using an export specification (or schema.ini), try exporting
without using the specification. If that succeeds, make sure that the
field names and types in the specification match those in the table; if
necessary, create a new specification and use that.

-The destination file could already exist and be locked by another
application, or be inaccessible for some other reason (e.g. you've
mistyped the path). Try exporting to a local folder like C:\ .

-The database could be corrupt (this is compatible with your having
problems with this one database but not with others). Make a backup and
then try Compact and Repair; if that doesn't fix it see
http://www.granite.ab.ca/access/corruptmdbs.htm

Please post back and say how you get on.
 
Back
Top