transfertext problem

[antdickens]

I am trying to import some data from the file i:\chance\stock.asc into the table called datafromchance using the spec saved as ant.

The text file contains comma seperated values

this is my code but it doesn't seem to be working. the error message in get is run time error 2495 the action or method requires a table name or method.


DoCmd.TransferText acImportDelim, ant, datafromchance, "i:\chance\stock.asc", no


i thought i had specified the table name as datafromchance and it does exist??


any ideas??

 

[tomschafer]

Gotta enclose it in quotes....
DoCmd.TransferText acImportDelim, ant, "datafromchance", "i:\chance\stock.asc", no