TransferText under XP

[DrSnuggles]

Hi,

I have this bit of code that tranfers a file into my Access 97 Db:

DoCmd.TransferText A_IMPORTFIXED, "ARCCAND.DAT", "CandidateIn", gstrImportDir & "\ARCCAND.DAT"

The last time I ran this was under NT. It doesn't work under XP now though.
Any clues?

Many thanks

 

[Surjer]

Whats the error you get? It might be that your import sepcification is now gone. Post back with more details.

 

[ghudson]

Try acImportFixed instead of A_IMPORTFIXED

 

[Surjer]

Good eye. I should have seen that...