Hi! Help is needed!
I created a nice database and a cool administrators panel. Everything was fine until the database got too large. It has few thousand records and it's very annoying to work on it using panel. The best option would be to download the database (it has only one table) to ms access and work on it locally.
I know about myodbc driver but the server with the database has firewalled port 3306 so this option won't work.
The best option would be using php (thats why I post my question in this forum). If it would be possible to connect to database, query it and get a full table, then post it as an attachment via email. Then localy open attachment as an ms access database, or import it to an existing database.
It's a bit messed up but I can't find any other option. Well maybe except one - using excel to CTRL+V a whole table view from internet explorer window. And then with access get excel spreadshet. I think it's possible but I'm not sure. The problem is that displaying a table with thousand rows in IE takes a lot of time and I think there maybe some problems with it, like time limits for IE or something like that.
I would like to know if there is any better way of doing this, maybe with php? I don't have access to the server with php so I can't compile it with any new addons or modules.
I created a nice database and a cool administrators panel. Everything was fine until the database got too large. It has few thousand records and it's very annoying to work on it using panel. The best option would be to download the database (it has only one table) to ms access and work on it locally.
I know about myodbc driver but the server with the database has firewalled port 3306 so this option won't work.
The best option would be using php (thats why I post my question in this forum). If it would be possible to connect to database, query it and get a full table, then post it as an attachment via email. Then localy open attachment as an ms access database, or import it to an existing database.
It's a bit messed up but I can't find any other option. Well maybe except one - using excel to CTRL+V a whole table view from internet explorer window. And then with access get excel spreadshet. I think it's possible but I'm not sure. The problem is that displaying a table with thousand rows in IE takes a lot of time and I think there maybe some problems with it, like time limits for IE or something like that.
I would like to know if there is any better way of doing this, maybe with php? I don't have access to the server with php so I can't compile it with any new addons or modules.
