CS can be used in OLE ways to obtain the EXCEL data, loop to fill into the DW, but in the WEBFORM should how to operate? WEBFORM cannot be used in OLE, I now have to EXCEL files uploaded to the server first, and then the parsing in what way?
Thank you very much!

CodePudding user response:

If the database is SQL, then the SQL stored procedure with reading EXCEL, search in the SQL version version, more

CodePudding user response:

If you can handle is a simple excel as CSV, or text, operated by OLE excel save as CSV or text, again

CodePudding user response:

Is at the moment, I can only support. CSV incoming, but. CSV isn't EXCEL file, not strong commonality, use more or EXCEL, OLE banned, as if in a WEBFORM I repeated CS to BS original code, OLE will return an error when connected to a specific application,