I early every day out a excel, the data quantity is about hundreds of thousands of small, although write function, half automation, but want to do a lot of processing, every process is slow,,, I want to ask this kind of situation can we better use access? I have SQL based, are not vba, difficult?

CodePudding user response:

With SQL, then use SQL server, excel as import data sources, a query process is as a result,

CodePudding user response:

Excel to those who never programming database operation is used to process the data, can not guarantee efficiency, have the ability to programming and database operation, data processing or use the database