Wierd problem with field names and vba

[redtux]

Hi
I have a process which I am amending which looks up data from a text file.

When I link the file manually using a spec file everything is fine with the
field names (CVS file)

However when I do exactly the same with vba
ie:
transfertext aclinkdelimited, weekly_spec, table,infile,True

the fieldnames have a # inserted in date fields and other minor changes
which mess up the procedure after this point

Anyone any idea what is going on here (using Access 2000)

thanks