If I understand you right, yes that is possible. You can use your Excel file and use third option in table wizard from which will be created table in database.
You can read more about this on this link. This table then you can use in your custom SQL queries.
You can find name of the table in option MySQL table name for editing on Editing table in table settings.(attachment)
You can try all of this on our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin premium features.
All useful information about all wpdatatables features that are explained (video and text) you can find in our DOCUMENTATION.
If this is not what you look for then please explain me in little more details on what you mean exactly and I will gave you my suggestion.
Hello,
I am wondering if it is possible to upload an excel table and then reference this table in an SQL query with your plugin?
I.e.
Upload Table A with 2 Fields, ID, Name
Join this to a wordpress table
Is this something that can be accomplished with your plugin
Thank you
Hi Ian,
Thank you for your purchase.
If I understand you right, yes that is possible. You can use your Excel file and use third option in table wizard from which will be created table in database.
You can read more about this on this link. This table then you can use in your custom SQL queries.
You can find name of the table in option MySQL table name for editing on Editing table in table settings.(attachment)
You can try all of this on our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin premium features.
All useful information about all wpdatatables features that are explained (video and text) you can find in our DOCUMENTATION.
If this is not what you look for then please explain me in little more details on what you mean exactly and I will gave you my suggestion.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables