append records in sql Server table from MS access table

[rkinfo]

How can I append rows to SQL server table from an MS access table?

My module was working fine to insert rows to linked sql server table but since I have dropped SQL database table I am not able to append rows. Although I am not getting any error message

 

[AlexCuse]

>>>>but since I have dropped SQL database table I am not able to append rows.

You can't link to a table that no longer exists. You need to re-create the table in SQL.

Hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[rkinfo]

Yes, after droping the table I have recreated the table. Then tried to insert records. I am able to insert records manually from MS access but not able to add new new records using VBA