Forum Discussion

Copper Contributor

Mar 28, 2022

Importing Multiple Text Files

Hi All, Is there a way to import multiple text file in MS access database. I have more than 50 - 60 file every time I need to import in access database.

access

sathishkm

Copper Contributor

Mar 29, 2022

Can you post the VBA code

George_Hepworth

Silver Contributor

Mar 29, 2022

It's in half a dozen procedures scattered over different modules and it is highly specific to one environment. It took a couple of weeks to work it all out and implement the supporting form.

I can make it available as is, but it'll be up to you to implement the concepts.