>Hi,
>
>I want to import data from a text file into Access table.
>When I try using the following command...
>DoCmd.TransferText acImportDelim, , "Table1", "C:\My Documents\My.txt"
>
>where "Table1" is the table in my database and "My.txt" is the notepad from which I want to import data.
>
>Execution of this statement gives me run-time error....
>Anyone have idea about what is wrong in this method or Is there any other method to accomplish this ???
>
>Thanks in advance,
>Shilpa

What's the error message and how does the file format look? (what's the delimiter?)