Importing Excel Files

[sathishkm]

Hi All,



I have a list of excel files in one particular location. Now I have to import all these files in to access. Is there any query or vb code to import all these files.

[June7]

VBA code to loop through files in folder and possibly TransferSpreadsheet to import. This is fairly common topic in forum. Start with:
http://www.allenbrowne.com/ser-59.html
https://www.accessforums.net/import-...les-27199.html
https://www.accessforums.net/access/...les-31024.html

Attempt code for your requirements and if you encounter specific issue, post question.

[ssanfu]

And another site by Ken Snell with code examples:
http://www.accessmvp.com/kdsnell/EXCEL_Import.htm