TransferText Method

[lopster10]

Hi Guys,

I have a access application which uses the TransferText method to write some data to a text file. Basically a temporary table is created, then the single record which populates it is written to the text file.

If I add another field to the create table query, I get an error saying:

"The Microsoft Jet database engine could not find the object". "

No matter how I create the table, even if I statically create it so its not temporary I get the same error.

I have looked up the TransferText method in the help and an optional specification parameter can be specified. This has been used and it says this should be a string expression stored in the current db. I tried to locate this but cannnot find where any sort of specification declaration.

Does anyone have any ideas of how I can identify this as I think this must be stopping me from adding an extra field to be written to the text file?

Any help appreciated

 

[lopster10]

Ahhh Ive finally worked this out from chance. When the temp table was created, I right clicked and exported, this also game me the option to re-create the specification file to include the new field name. After doing this the function worked perfectly.

I still dont know how to view the current specification though, which is strange!