Skip to main content
  Tuesday, August 14 2018
  2 Replies
  1.1K Visits
  Subscribe
Greetings!

I have census data records exported from an Access database to Excel. Some tables have more than 200,000 records. I am unable to import them to mySQL. Do you think DropTables will handle it? Also, are the filtering options only per column, or is there a full table search as well? We'd like the public to be able to search these tables not only by column alone, but also by any term that will search the whole table.

I'd like to sync to the Excel sheets, but am concerned about the site of the table.

Thanks in advance!
R
5 years ago
Greetings!

I have census data records exported from an Access database to Excel. Some tables have more than 200,000 records. I am unable to import them to mySQL. Do you think DropTables will handle it? Also, are the filtering options only per column, or is there a full table search as well? We'd like the public to be able to search these tables not only by column alone, but also by any term that will search the whole table.

I'd like to sync to the Excel sheets, but am concerned about the size of the table.

Thanks in advance!
A
5 years ago
Hi,

Thanks for contacting us here about this extension.
I have census data records exported from an Access database to Excel. Some tables have more than 200,000 records. I am unable to import them to mySQL. Do you think DropTables will handle it?

I think it's impossible now, it works well with around 2000 cells only.
are the filtering options only per column, or is there a full table search as well?

We have filters for each columns. You can see the sort feature here:
https://www.joomunited.com/documentation/droptables-documentation#toc-3-2-theme-and-sorting-options

Hope it helps!
Cheers,
  • Page :
  • 1
There are no replies made for this post yet.