Lipper
Last Activity: Jun 18 '10, 06:54 PM
Joined: Mar 16 '10
Location:
-
I want to thank you both for helping me out with this. One more thought, do any of you know any method that will exclude a number of top rows as opposed to defining a range? -
Say the "Range" may change from time to time, and I was trying to find an easier way to input the cell range other than directly into the code, any ideas?Leave a comment:
-
Thanks, I used the following code below, and it works out pretty good.
Code:DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, _ "Worksheet Name", "Path Name", True, "Range"Leave a comment:
-
As of now yes. I am receiving an excel file that will come in the same format periodically.Leave a comment:
-
Import Excel File without Specific Rows
Is there a way to automate a process to import an excel spreadsheet without the first and last couple of rows into Access?
No activity results to display
Leave a comment: