score:0
because you are doing docmd.transfertext, access is expecting that the file test1.txt exists in that location. try creating the file first, and then do a transfer of the text.
you can try this code before the export to create the file:
public sub createexportfile()
dim strfilename as string
dim somestringtooutput
strfilename = "d:\myfolder\test1.txt"
open strfilename for output as #1
end sub
score:0
i was having a similar situation and found that a file schema.ini was in the destination folder. this was created when an acexportmerge was performed previously and it caused this error. make sure that file has been deleted prior to executing a new transfertext.
score:1
the microsoft office access databasse engine could not find the object "test1#txt". make sure the object exists and that you spell its name and path name correctly.
this is a generic (and rather useless) error message that access outputs in case anything goes wrong. one example would be a misspelled field name in the import/export specification.
you can get the "real" error message by trying the import operation "manually" in the access user interface (rather than through code).
score:1
the question author reported the problem was "because i was using an import specification for exporting a file."
they resolved the problem by using an export specification.
Source: stackoverflow.com
Related Query
- Microsoft office Access database engine could not find the object
- Microsoft Access database engine could not find the object Worksheet - ACE OLEDB
- Microsoft Access database engine could not find the object Sheet - ACE OLEDB
- The Microsoft Jet database engine could not find the object "SELECT * FROM funk"
- Access Database Engine could not find object - object is Excel named range
- How can I update multiple records which match with the Environ Username? Microsoft Access database engine cannot find the input table
- The Microsoft Access database engine cannot find a record in the table 'Vlasnik' with key matching field(s) 'Narudzba.ID_VU
- What's the error number for "'The database engine could not lock table"?
- Excel VBA ADO SQL connection error - Could not find the object
- Runtime Error 2147024809 (80070057): Could not find the specified object
- Ms.access, importing error, database engine couldn't find the object "..."
- Macro - Query - Microsoft Access database engine stopped the process
- Why do I not see the Microsoft Forms 2.0 Object Library?
- How to check from .net code whether "Trust access to the VBA project object model" is enabled or not for an Excel application?
- Microsoft Access can't find the field '|1'
- SQL Statement to work on a Microsoft Access Database which will get Top 5 Records but Skip the first 5
- 'Error 380: Could not set the RowSource property. Invalid Property value' for Excel user form to import data from Access to Excel
- How to execute code from a Module that resides in Microsoft Office Access Class Object
- Run-time error '2110':` Microsoft Office Access can't move the focus to the control
- I can not access all the tables in my sql database
- Access ADO: operation is not allowed when the object is closed error message
- OLEDB connection to Access database with password: "Could not find installable ISAM"
- MS Access 2016 VBA Error 2424 the expression you entered has a field, control, or property name that Microsoft Access cannot find
- How Can I Avoid the Following Error Message: "Operation is not allowed when the object is closed" When Inserting a Record into an MS Access Table?
- Unbound OLE object controller - Change picture via VBA - Microsoft Office Access
- Access VBA not working to find entries in database between a date range
- Can multiple users connect to a Microsoft Access database at the same time using Java?
- What are the implications of running a Microsoft access database in both 2003 and 2007?
- Microsoft Word 2010 VBA: Find Using Wildcards getting an error that the text contains a pattern match expression which is not valid
- Can't set focus on my Subform in Access - error 2465 (can not find the field '|1' referred to in your expression)
More Query from same tag
- Delete cell after copied for 30 seconds
- Assign a hotkey to execute a .vbs file through its desktop shortcut
- Connecting Excel to Outlook
- How to save Outlook attachments in subfolders based on Subject string
- Draw line on last record of each report page
- Excel Userform "Apply" button
- Excel VBA: Argument Not Optional Error When Adding To An Array
- Merge cells in Excel
- Create Pivot Table
- excel copy and paste in Windows Search
- VBA - Loading master workbook using another workbook
- Excel VBA - How to stop macro from working during public holiday
- Convert Windows API call to 64-bit in Excel VBA
- Summary Sheet That Updates Source Sheets
- What is the equivalent of this code for MacOS excel?
- How to remove duplicates for columns
- MS Access 2007 - Print MultiTabbed Report - VBA
- Word crashes on removing a Shape with VBA from a header
- Passing a string parameter with many commas in SQL through Excel ADO
- Copying sheets from closed files? format during or after?
- Data export from Excel to CSV
- VBA Incorrect parameter using 7z with command
- VBA sorting mechanism not working on second sheet
- How to add all message boxes into on final message box in VBA?
- Making the criteria in a SUMIF function relative to the active cell
- After using Application.FileDialog(msoFileDialogFilePicker), how can I save that selected file to a predetermined path?
- Date Filter Hiding All Cells Through Excel VBA
- Parsing JSON data into Excel sheet
- VBA ActiveX label in a sheet
- Delete n% of the rows from the excel sheet on click of the button using VBA or any excel formula if possible