Read From text Fiel function

[pakistranger]

Hi Guys, I am willing to design a form where I could browse the files and a button should read from text file and insert values into my Table. Please help me in this regard.

I want to have a function with parameters like text file name and destination table. Any clue will be highly appreciated

Cheers
Abid Hussain

 

[KeithG]

So you want to be able to select a text file and a table name and transfer the data from the file to the table?

 

[pakistranger]

Yes thats right and it is a task at job need to be finished by tomorrow. Could someone help please?

 

[KeithG]

Why can't you just import the file? You could create a form for the user to input the path of the file.

 

[pakistranger]

The problem is I want to import it to a table anlready there that a user can select from a combo box and If I try to do that I will have to deal with Specification file. SO it wont be an automated procedure as the specification need to exist there. So is there anyway of doing this without specification or anyway to define specification on run time. I will appreciate it much .