Table 'Table1' already exists..

조회 수: 8 (최근 30일)
cief
cief 2020년 5월 27일
댓글: Robert Caudill 2023년 10월 24일
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
Robert Caudill
Robert Caudill 2023년 10월 24일
I get the same error when using 2019b. Is there a solution for appending records to an existing MS Access database table?

댓글을 달려면 로그인하십시오.

답변 (0개)

카테고리

Help CenterFile Exchange에서 Database Toolbox에 대해 자세히 알아보기

제품


릴리스

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by