Hi guys,

I have a .txt file that I wish to import into access (using an automated
method). Some of the field names have full stops in them.  When I import it
using the wizard these import correctly.  If I try and use transfertext the .
get replaced by #

Here's my code: DoCmd.TransferText , , "annual outputs random seed 12
colon", "filename", -1

Probably doing something klutzy but can't see what!  Any thoughts?

Thx