Search results
-
E
Import Specific Worksheet From Excel
That works perfectly! Thanks!! I appreciate your assistance! Right now, I'm deleting the entire table and then calling the ImportExcel VBA...if there's an easier method, without having to close the table and reopening it, that would be awesome! DoCmd.SetWarnings False 'SQL delete statement...- esneaker
- Post #5
- Forum: Modules & VBA
-
E
Import Specific Worksheet From Excel
Greetings! Yes, each workbook has the same field name, same column count, and same sheet name "Access".- esneaker
- Post #3
- Forum: Modules & VBA
-
E
Import Specific Worksheet From Excel
Greetings!! I am new to MS Access and have been trying to use VBA to import a specific worksheet called "Access" in an Excel file (from about 400 users) into a single table. I want the code to search through one folder and import the "Access" worksheet in each Excel workbook within that...- esneaker
- Thread
- Replies: 5
- Forum: Modules & VBA