Table 'Table1' already exists..

8 vues (au cours des 30 derniers jours)
cief
cief le 27 Mai 2020
Commenté : Robert Caudill le 24 Oct 2023
Hello,
So I a trying to insert data ( a row) into Table1 using the command:
sqlwrite(conn, tablename, data)
everytime I run this command I get the following error
Error using database.odbc.connection/sqlwrite (line 133)
ODBC Error: ODBC Driver Error: ODBC Driver Error: [Microsoft][ODBC Microsoft Access Driver] Table 'Table1' already exists..
I tried to change the tablename( created a new one) and it worked.
I saw some old posts on here but those didn't help me.
Thanks for the help.
  1 commentaire
Robert Caudill
Robert Caudill le 24 Oct 2023
I get the same error when using 2019b. Is there a solution for appending records to an existing MS Access database table?

Connectez-vous pour commenter.

Réponses (0)

Produits


Version

R2019b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by