VB script to load Excle files to Access Database

[get4peterin]

Hi,

I have one requirement where a folder would contain multiple excel files. The data present in these multiple excel files needs to be loaded to the access database. Is it possible to do through VB batch script which processes multiple excel files and loads them to the Access database? If anybody has a script which does this can you please share it with me?

Thanks,
Peter

 

[ajetrumpet]

I'm not going to write a script, but research the FSO file picker within a directory. You can look through all files, open them, and do whatever you want...one by one. If you research, you will find it.

 

[HiTechCoach]

Hi,

I have one requirement where a folder would contain multiple excel files. The data present in these multiple excel files needs to be loaded to the access database. Is it possible to do through VB batch script which processes multiple excel files and loads them to the Access database? If anybody has a script which does this can you please share it with me?

Thanks,
Peter

Since you are using Access, check the VBA (not VB) help file for the use of DIR() to get all the file names.

You can use TransferSpreadsheet to read in the Excel files