Import multiple txt files into single Access 2013 table

[AndyDevine1]

Hi guys

I've tried to find a post which relates to importing txt files into a single Access table (i have 100 to import, all with the same format headers)

I've found code on posts which does not work as, upon further investigation, some of the code eg "FileSearch" will not work in my versions of Access, Access 2013

Can anyone help me with the code please?

I can modify it to read from correct folder etc

Many thanks

Andy

 

[Joe4]

Check out the last post in this link: automatically import multiple excel files in the same folder to access 2003 table - Access World Forums

There is nothing specific in that code that should prevent it from working in Access 2013.

 

[AndyDevine1]

Thanks for that

I've run the code and I get "user defined type not defined" error message at "Dim FSO As New FileSystemObject"

Also, should the code work for all file types not just excel?

Can you help?

Thanks

 

[Joe4]

You will need to add the appropriate Library references to use code that uses File System Objects or DAO. But if you look at the last post in that thread, I think the code there does not require anything like that.