Question Importing txt into access

[msmontes]

Hello there.
I need help creating a import form into access.

File format is txt (tab delimited)

Ideally I need:
- a box to enter the file name
- a box to enter the path
- a import button to push

And I have no idea how to do it? Anyone around to help?

I have seem some comments saying you have to creat a transfer text.... - not sure the name now.

However I have no knowlegde of Coding, opening or closing statments... so if someone could give me this help I would be very happy!

Many thanks.

S.

 

[Estuardo]

G'd Afternoon,
You don't need to do that. MS Access already have a wizard to do that.
Ribbon-->External Data-->Import & Link-->text file.

G'd luck