How Does Access Detect First Row Contains Field Names

D

dkrumholz

In Access 2003 how can I get an import specification to automatically
understand that my imcoming txt file has a header row? Under what
condition(s) does Access know that?
 
B

bhicks11 via AccessMonster.com

Use the transfertext command which has an option of true or false for header.
Here's your syntax example which includes a specification:

DoCmd.TransferText acExportDelim, "Standard Output", _
"External Report", "C:\Txtfiles\April.doc"

Or, the transfertext macro command also has an option for header.

Bonnie
http://www.dataplus-svc.com
 
Top