Import Data into Access from Excel File

[Waqas ali]

Dear All,

i am importing data from excel file to access table using below code
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, "Table1", "C:\myTemp\AccessUpload.xls", True

now i want to save system date and time with each imported record.

i checked table properties there is an attribute modified when ever i imported it is showing last modified.

how can i update same modified information with each imported record.

 

[Trevor G]

Create a duplicate copy of the table structure and add the date and time field, then create an append query and add the date time field into the query and then run the query this can also be done through VBA or a macro, then empty the first table.

 

[Waqas ali]

thanks before i did same any other option

 

[Trevor G]

Add the date and time in the excel table before you upload it.

 

[Waqas ali]

i dont want it by manually

 

[Trevor G]

My first suggestion then.

 

[Joe4]

See here: https://support.office.com/en-sg/ar...-records-2abe2c7b-7256-4814-aae5-47e4d262e5e9