Is a great god, if use VBA program to access the SQL server2008 database how to write, not completely before VBA, have a great god tell it to me

CodePudding user response:

I suggest you, in turn, used to access the excel,

You must visit is essentially, it is recommended that you write a program to access the essentially, processed the data export to excel,

CodePudding user response:

Don't write VB code, can be directly from the Excel SQL Server,

Excel \ Data \ the From Other Sources, From SQL Server, if you have installed SQL Server can Configure the connection directly From here,

CodePudding user response:

I've done can access now, but is I changed the sa password, use excel to enable macros can he speak now users' "sa" login failed, error 3704. The object is closed to operate, is this why

CodePudding user response:

You changed the access to information, you have to configure the connection to SQL Server in Excel

CodePudding user response:

Good to solve the