I am facing an issue in importing data from excel sheet to MS Access table.
The issue is I am trying to import excel sheet that contains 100 records into access table. Both the excel sheet and access table have same field names. Now the issue is when i use the MS Access | File | Get External data | import .... it will import the data from excel sheet to ms access table. It shows all the 100 records at the beginning in Access table. MS Access table already contains 5000 records. What I need is that those 100 records must be appended into the access table.
So the only problem i am facing is the position of records I need the records at the end of the records in MS Access table not in the beginning....
Pls help.
The issue is I am trying to import excel sheet that contains 100 records into access table. Both the excel sheet and access table have same field names. Now the issue is when i use the MS Access | File | Get External data | import .... it will import the data from excel sheet to ms access table. It shows all the 100 records at the beginning in Access table. MS Access table already contains 5000 records. What I need is that those 100 records must be appended into the access table.
So the only problem i am facing is the position of records I need the records at the end of the records in MS Access table not in the beginning....
Pls help.