Merging selected data from Excel to Access

[TC]

I have a Access database (A.mdb)and mistakenly extracted the data to Excel E.xls)without a link.I made some modifications in Excel and want them to be added to Access(A.mdb) the modified items.Need to do it immdeately and if anybody knows idea please help me..Now I am entering the modified items manually...
Thanks in advance
_TC

 

[BigC]

TC
Its a little while since I did this, but try:
- make sure each column has a unique field name
- name the range of records in Excel with a useful range name (slect range / insert / name / define / ok)
- Save & close the workbook
- In Access A.mdb, File / Get External Data / Create Link (??)

This last step should create a link from your Access database to the Excel workbook, which you can then refer to as a table (it should show in the Table objects listing)
-run a query to identify the modified records (use an append query to add them to the existing table)
Something like that.

Also check Access Help re external links to Excel.

HTH

 

[TC]

Thanks for the advice ..But now struggling with query ..Could U also explain it.Now I brought the modified data M.mdb and Base Access Database (A.mdb)How to merge them by query?
_TC