Making a button to import .csv files

[marleyuk]

Hello, i want to make a button on my form to input .csv files. What is the best way to do this? I simply want to click the button and be asked for the csv location, i want the csv to be imported and be formatted. Whats the best way to do this?

 

[Ian C]

Try calling the "DoCmd.TransferText" command from the on click event of a button. Access help gives you info on what variables you need for this command. You could get the user to these variables in the form and reference the form from the command.

 

[marleyuk]

I have made a button and right clicked, I set the on click command as "DoCmd.TransferText", but i dont understand how to reference the form to the command.