Is there a way to import all excel spreadsheets from a specified path. for example, i have 20 spreadsheets in one path c:\documents\ftp and want to include all of the spreadsheets in that location.
Thanks in advance for the help!
Raymond
Is there a way to import all excel spreadsheets from a specified path. for example, i have 20 spreadsheets in one path c:\documents\ftp and want to include all of the spreadsheets in that location.
Thanks in advance for the help!
Raymond
Yes, VBA could do this. The exact nature of the code depends on the structure of the spreadsheets. If the structure is simple enough maybe just TransferSpreadsheet method will serve. So code would loop through the folder and get each Excel file and do import procedure.
You have already been referred to code for getting files in a folder. Inside the loop to get files have code to import the data. Review: http://forums.aspfree.com/microsoft-...el-413629.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I am actually glad I took the time because this worked fairly seamlessly except i didnt realize it pulled everything in so when i deleted it out of the database everything was gone in the destination folder! thank god for terabyte external backup drives Now i will put a post in the forum or search first on how to just show the duplicates in the table. maybe a simple query will do this. thanks!
Can do an aggregate (GROUP BY) query that counts the values that should be unique. This should expose duplicates.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.