Make table of Excel spreadsheets and tabs from a folder
Posted on 2009-05-12
* I need to have Access create a table that lists the filename, filedate, filesize, filepath for a given folder for Excel, Text, and CSV files. (This example please use c:\IncomingData.)
* I also need a way to identify and import multiple tabs within the same Excel file. I imagine that there would be a separate table for each Excel file with a row for each tab.
I will be using the above to import the contents of these files (and tabs) into one table that has the column headers of Field01, Field02, Field03, etc. Based on the Filename (and tab name for Excel) I have a schema table that identifies the contents of each field for further processing.
I appreciate any help in getting this information into Access.