excel append to access

[willy292]

I have some excel raw files ,under a subfolder namely daily ,lets say, called abc_220913.xls
there are three worksheets in the excel called sheet1, sheet2,sheet3

only the extension which is "ddmmyy" meet today's date with be append into datebase and I need to append sheet2 only of abc_ddmmyy.xls everyday

The database is of the following structure

Field Type
Ledger Text
Market Text
Product Text
Trade Date Date
Volume Number
Price Number
CCY Text
Net Charges Number
Net Tax Number
Total Charge Number

 

[pr2-eugin]

I think you need to first look for the file using the Dir method, if it exists then use DoCmd.TransferSpreadsheet to acImport the File, using the Sheet2 as the Range.