Exporting Table to Text file including Field names

[AShi]

When i am using following

DoCmd.TransferText acExportFixed, strExportSpec, strTable,
"\\Enterprise\mlhsapps\ExportTest.txt", True fieldnames are seperated by
comma istead of fixex width

Can some one help me with this

 

[Jackie L]

You need to verify/change that in your export specification (strExportSpec).

 

[AShi]

I have done that.

You need to verify/change that in your export specification (strExportSpec).

 

[Gina Whipp]

AShi,

Try creating a new Export Specification and see if that produces the same
issue. Also, what version of Access?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[AShi]

I tried- it did not change. wehave access 2003

AShi,

Try creating a new Export Specification and see if that produces the same
issue. Also, what version of Access?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Gina Whipp]

Fixed width has no option to to save column names... Have you confirmed
that you are using Delimited?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Gina Whipp]

Okay just saw that... you say acExportFixed, that will NOT export with
Field Names. You need acExportText.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[AShi]

tried it acExportText

gives error novariable found

 

[AShi]

when i export to delimitted - some how it adds time to date. I am sure I
don't have tlme in export specs

 

[Gina Whipp]

AShi,

What do strExportSpec and strTable represent? In other words, where is the
balance of the code?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[AShi]

Private Sub cmdExport_Click()

Dim strTable, strPath, strLine, strTemp As String
Dim X As Integer
Dim BlkRow As Integer
Dim strSQL As String
Dim strExportSpec As String
Dim fs, f
Dim fso, myfile, objTxt As Object

strTable = FirstSelected

Select Case Left(strTable, 5)
Case Is = "A2DEV"
strExportSpec = "A2DEV3_ExportSpec1"
Case Is = "A2DV1"
strExportSpec = "A2DEV3_ExportSpec"

End Select

'Export to temporary text file
DoCmd.TransferText acExporText, strExportSpec, strTable,
"\\Enterprise\mlhsapps\ExportTest.txt", True

 

[Gina Whipp]

Have confirmed that BOTH specifications have the Include Field Names
checked?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[AShi]

yes

Have confirmed that BOTH specifications have the Include Field Names
checked?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Gina Whipp]

Running out of ideas... Okay, let's try this. Export those tables
*manually* and see if it exports with field names.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm