Hi all, I got Access Database on path "C:\Data\Rec.mdb". I got one
table in that database with the name "Table1" with five columns in
it. I want macro in excel which should delete all the records in
"Table1" and then copy Range("A2:E100") of Sheet2 and paste it into
"Table1". (Note: headings in Range("A1:E1") of Sheet2 are exctly
match with the "Table1" headings). Please can any friend help me on
this. I dont know if its possible or not!