Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to delete rows after importing from Excel
Ok here is what’s going on... before when I would download my spreadsheet off of the web page they left a few spaces blank in columns 1 and 2 starting at row 6, and my co-worker wrote the program based on that. Now he is gone and they changed their spreadsheet and I no longer need to fill in any...- mill97
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
How to delete rows after importing from Excel
Hi I weekly import an excel spread sheet into access but i dont need the top 4 rows. So for this is what i have written Public Sub Command1_Click() DoCmd.TransferSpreadsheet acImport, 9, "Training", "...Adls Roster\Training.xlsx", True Rows("1:4").Select Selection.Delete Shift:=xlUp...- mill97
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
