Transfer Spreadsheet - able to limit by data????

[unc2plo]

I have a db that uses transfer spreadhseet to upload some data. Is there a way to limit what data gets brought across? Can I say bring over only items within a certain date range?

This what teh code says now......

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblExcelLoad", Me.cdg1.FileName, True

Thanks,
David

 

[Joe4]

I would recommend trying to limit before or after the import, not during the import.

There are a number of ways to do it. One way is to import the data into a temporary access table, then create an Append Query that limits the data according to your desired criteria, and then adds those records to your final table.

 

[unc2plo]

oooohh, I like that.

I inherited this db, and it is way too reliant on code which makes it tough to rework.

Thanks - your comment really showed me that I need to look at this a different way vs trying to live within the constraints that it places on me.