Data Publisher
» Flat table
» Responsive table
» Responsive table with media library intergration
» Responsive table with static hyperlinks
» Responsive table with dynamic hyperlinks
Data Projects
Shortcodes
» Shortcode wpdataaccess
» Shortcode wpdadiehard
I’ve got the WP Data Access plugin installed, and I’ve managed to create a table and display the shortcode so that it shows on the test sample page. However, how do I get data into those tables? I have a lot of data in many different excel spreadsheets. So I was looking at a way to potentially take the data from excel and import it into these WP data access tables, or at least manually enter it in. What I am trying to do is essentially have a portal where our employees can collaborate more efficiently to update company records/site addresses/internet service provider accounts, etc.
Hi John,
You can export your Excel data to CSV (save as) and use the plugin to import your CSV data into your database table. The CSV import is available from the Data Explorer main page. Here is a link to a tutorial for CSV imports:
https://wpdataaccess.com/docs/documentation/data-explorer/import-csv-file/
Hope this helps,
Peter