• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 438
  • Last Modified:

DoCmd.TranferText gives error "Microsoft Jet Database engine could not find object xxx#txt

In an Access 2000 app, I am trying to export data from a table to a text file using the transfer text method. This worked fine until I recently altered the query that updates the table and increased the number of fields in the table to match the new query. Could it be that the table is now too large. I did not change any of the code in VB.
0
Ucaihc
Asked:
Ucaihc
  • 2
  • 2
  • 2
1 Solution
 
nico5038Commented:
Looks to me that your filespecification hasn't been changed according the changes in the query.
Can you post the docmd.transfertext statement ?

Nic;o)
0
 
rockiroadsCommented:
if u use a file specification, does it work if you dont have a file specification?
if so, it will prove Nico's point

DoCmd.TransferText acExportDelim, <filespec>, <tablename>, <outputfilename>
0
 
UcaihcAuthor Commented:
If I don't have a file specification, it does not work.

Here is the statement:
---DoCmd.TransferText acExportFixed, "CVSTemp_Export", "CVSTemp_Table", stDocName ---

The stDocName is created in the lines before.
How would I change the file specification?
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
rockiroadsCommented:
The 2nd parameter is your specification - CVSTemp_Export

go to File/Get External Data/Import

select data type txt,
pick a file e.g

select Advanced
click on Specs to see your import specifications

0
 
UcaihcAuthor Commented:
Yes, the fields have changed.

Can I change them there and then save the changes, or do I need to change them somewhere else?
0
 
nico5038Commented:
Change them there and save :-)

Nic;o)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now