Importing files via a macro 1

[Dimonet]

I would like to import multiple files into a DB through a macro. What is the command to import a file via a macro including calling the location / spec and destination?

Thanks

 

[CautionMP]

Dimonet,
[tt]DoCmd.TransferText(acImportDelim, [SpecificationName], [TableName], [FileName])[/tt] sounds about right.

Hope this helps,
CMP

(GMT-07:00) Mountain Time (US & Canada)

 

[Dimonet]

Sorry for my ignorance. In the Macro step which action should I choose to then input the example you sent. Thanks in advance for your assistance.

 

[Dimonet]

I figured it out. Thanks very much for your assistance!