export to text file problems

[Keith G Hicks]

Using A2003 with A2k format & ADP (not mdb).

I'm converting an mdb to adp. In the mdb we had been using the following to
export text

DoCmd.TransferText acExportDelim, "ZqryTempForAttyNoticeList Export
Specification", "ZqryTempForAttyNoticeList", sDefaultFolder & sFileName,
False

This has always run just fine. Now that I'm in the ADP world and there is no
such thing as a stored export spec, I'm stuck. I figured I'd use a
schema.ini but I'm not having any success with that. Here's what I've got so
far.

I'm using a stored procedure to post data to a permanent temp table. Then in
the adp I'm doing this:

DoCmd.TransferText acExportDelim, , "tblTempNoticeExportToTextFile",
strSaveToPathAndFileName, False

This runs ok but of cousre this just uses the default export settings
(CSVDelimited with double quote as text delimiter) when there's no
schema.ini

I need the file to be a tab delimited and no quotes around text at all. I
thought I'd create my own schema.ini but every time I do the above code just
overwrites it or adds a new section to it. It seems that it doesn't make use
of it at all. And the help on this topic is really crappy. And everyone
online just says to use a schema.ini with no further explanation.

I didn't post this to the adp newsgroup because the fact that I'm using an
apd shouldn't really matter here. I know that a schema.ini can be used in an
mdb as well and that's the main problem.

Can anyone point me to some better information or fill me on on what I'm
doign wrong here?

Thanks,

Keith

 

[Keith G Hicks]

Well I decided to try this: http://support.microsoft.com/kb/210001
It works to a point. I still need the quote around the text to not be there.
Not sure what to set to do that.

Keith

 

[Keith G Hicks]

For anyone that might be interested, the line that's needed in the
schema.ini for this is:

TextDelimiter = "none"