Problems using transfertext

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Sorted now - I set up a specification. No idea why it was being tempremental
without it tho :$
 
Back
Top