VBA code importe txt file

[lena_form]

Hello!
How can I, in VBA, create a code that I import a txt file, without going
through the window of data import. That is, vba should have all the code to
import directly.

Thank

 

[Ken Snell]

Check out DoCmd.TransferText action in VBA help.

 

[ryguy7272]

If I were you, I'd create a macro to do this, then convert the macro to VBA,
then link the code to a Command Button. See this:
http://www.databasedev.co.uk/text-import-macro.html

Post back if you have more questions.