Export Delimited

[rowdycajun]

Trying to create macro to automate the export of a query to tab delimited
text file.

Transfer Type: Export Delimited
Specification Name: Tab Delimited Export Specification
Table Name: T558c Table (this is the name of a query)
File Name: C:\Documents and Settings\my name\My Documents\Exports\T558c.txt
Has Field Names:no
HTML Table Name: blank
Code Page: blank

My error message: The Microsoft Jet database engine could not find the
object 'T558C.txt'. Make sure the objects exists and the you spell its name
and the path name correctly.

The macro is suppose to be creating the file so why must the file already
exist? Even if it exist I still get the same error.
Not sure if just type the query name in the Table Name field is correct way
to do this.

 

[Chris O'C via AccessMonster.com]

Take another look at the Table Name in your macro. If it's T558C.txt instead
of T558c Table, you'll get that error message. Type the query name exactly
as you see it in the database window, spaces and all.

Chris
Microsoft MVP

 

[rowdycajun]

That was just a typo when I was typing up this question. Anyhow I change
removed txt from the file name and I'm getting a different error. Cannot
update. Database or objects is read-only.

 

[Chris O'C via AccessMonster.com]

The text driver requires a valid file name extension. Valid file name
extensions for your version of Access are: .txt, .tab, .csv, .asc. If you
don't use one of these, you get the error message you mentioned and you can't
export the data.

Whatever your typo is, fix it so the table name item in the macro matches a
query name in your db.

Chris
Microsoft MVP