USMCFROSTY
Registered User.
- Local time
- Today, 02:42
- Joined
- Mar 5, 2007
- Messages
- 64
The code below works fine but how can i import all .xls within the folder. Can i rename the .xls to .xls1, .xls2, ect... then import the folder? How would i change the code to id them all then import?
Private Sub Command0_Click()
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, _
"AutoImportTest", "C:\Documents and Settings\me\Desktop\ImportTest.xls", True
End Sub
Private Sub Command0_Click()
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, _
"AutoImportTest", "C:\Documents and Settings\me\Desktop\ImportTest.xls", True
End Sub