Add Columns to Existing EXCEL VBA/MYSQL Import process
Budget: $10 – $30 USD
I already have an Excel workbook that lets me paste text rows into a single cell; a VBA routine then parses that text and Imports rows into MySQL tables. The current workflow is solid—I simply need the same macro to handle three extra fields and place into the matching columns in the database.
I'd need the VBA that gets these 3 data fields, and passes them to the MYSQL stored procedure.
I can provide the Excel file, and the MYSQL stored proc that Excel calls that already recieves and Inserts rows.
I attached a screenshot of sample data, the VBA import code, and the columns needed and where located.
I'd need the VBA that gets these 3 data fields, and passes them to the MYSQL stored procedure.
I can provide the Excel file, and the MYSQL stored proc that Excel calls that already recieves and Inserts rows.
I attached a screenshot of sample data, the VBA import code, and the columns needed and where located.