Problems using transfertext

[Muttley]

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

 

[Muttley]

Sorted now - I set up a specification. No idea why it was being tempremental
without it tho :$