Import Data from Excel

[Waqas ali]

hi all,

i want to creat a form in access to import data from excel.
how can i import and how can i overright on existing data if it is matching and already existing in table

thanks

 

[Waqas ali]

Re: Import Data from Excel to access

hi all
how can i import and how can i overright on existing data if it is matching and already existing in table

 

[Joe4]

how can i import and how can i overright on existing data if it is matching and already existing in table

Import it into a Temporary Table and create an Update Query between the Temporary Table and Final table, updating your desired fields for the records that match.