hello
I have a Database in Access 2003 Named "A",which Contains Table Tr
in Excel 2007 , i Create Same data base in WorkBook "B", worksheet"W" with same format and fields
i want to create a query to import data from workbook B to Table A
in that process i can do two process
First, Delete all data in Table A ,then append all data from Workbook
Second , Append data from Workbook B to Table A
Pls tell me how can i do that
I have a Database in Access 2003 Named "A",which Contains Table Tr
in Excel 2007 , i Create Same data base in WorkBook "B", worksheet"W" with same format and fields
i want to create a query to import data from workbook B to Table A
in that process i can do two process
First, Delete all data in Table A ,then append all data from Workbook
Second , Append data from Workbook B to Table A
Pls tell me how can i do that
