In the company on the server, Shared a folder & lt; Quality data & gt; , there are two files, one is the ACCESS database file, one is the EXCEL file, want to use EXCEL file as the entry form, ACCESS to the database, in EXCEL input to the database through a button to upload the data in the table (fails to cover existing data), after each time to upload the data to empty data in EXCEL worksheets, ask ace to give a code, thank you!!!!! Thank you very much!!

CodePudding user response:

Baidu search "VBA, Excel the Access"

CodePudding user response:

Excel as a database file does not support the Delete command, you'd better use access database, do not know you to two kinds of database is what meaning, if use VBA, access can also be used,

CodePudding user response:

You give the data model, I can give you do a

CodePudding user response:

Model post data

CodePudding user response:

Suggest using SQL SERVER database