Good morning all,
I am importing a table from an SQL data base using an ODBC data source. Every time I import this table it creates a new table in my Access database (Access 2000) with '1' at the end. I then have to delete the old one and rename the new. I would like to be able to replace the exisiting data when I import the new.
I haven't been able to find the answer using the Access help features and the searches I have done in this forum have not given me the information I am looking for.
Any suggestions? I would also be interested in automating this process if possible.
I am importing a table from an SQL data base using an ODBC data source. Every time I import this table it creates a new table in my Access database (Access 2000) with '1' at the end. I then have to delete the old one and rename the new. I would like to be able to replace the exisiting data when I import the new.
I haven't been able to find the answer using the Access help features and the searches I have done in this forum have not given me the information I am looking for.
Any suggestions? I would also be interested in automating this process if possible.
