Hello All,
I've been loving this forum so far. I've been learning so much.
One of the topics I've come to know quite well is the Transferspreadsheet command.
TransferSpreadsheet(TransferType, SpreadsheetType, TableName, FileName, HasFieldNames, Range, UseOA)
I learned that you can define the range of the spreadsheet one would like to import.
As of right now, some of the information I'd be uploading will come from another online database and is downloaded into the same format each time.
I was hoping that in order speed up the process of appending data to my access database I could have 1 excel spreadsheet and then define the range specifically.
In general the range should be defined something like
A1:F5
Could I do this:
A1:B5;D1:F5
etc