Recent content by irade92

Hi How to make Numlock to be always on in Access

Right. I establish conn sucsessfuly, sql file is ok and is cheked in mysql workbench. The problem is in sql file and maybe mysql version on server. The questionis how to fix it

Hi I have a little problem..Trying to update field in ODBC linked table from Local table. Here is my code..see pict Code when code reach cmd.Exceute I got this message...see pic Error My sql file in store procesure is ..see updatekolicini.sql Any sugestion or help Thanks in advance

let put it this way...I have three PC working on front end and adding some data to local tables and when they finished, they transfer the data into ODBC connected table in MySQL server..tranffering this data is slow. I use append query from local tables to ODBC linked table.

Hi..I have the same problem, slowdown from local table to MySQL server, with querries... Any idea how to fasten it?

After that going back to my frontend file and connect new table with ODBC and that is. Delete local table..this is the fastest way by now. All about 5 min

All I do is folowing: export data from my local table to Excel file which is few seconds. I oppend Excell file and than Save as OpenDocument Spreadshhet on my PC. Then go to MyPHPAdmin and there is option Import. I import file OpenDocument Spreadshhet with cheked "My file has column" and again...

I am not keeping append query for myself. It is usual query generated by Access. As I said, it is about transfering data from local table ( only one table) of my PC to ODBC connected tabel. If you want it I can send you SQL lines..nothing special..data are not goig from one SQL server to...

No, but is much slower than what I explained

I was using append query, one local table to another ODBC table. 20000 records transfered in about 3 hours. So what about 100.000 records?. . I was experimenting with more option as in Xml, Exel, csv but finaly did it with OpenDocument spreadsheet. I was transfering data to myPHP Admin in...

Here there was not such possibily..I cheked all before this step.. this is fastest way of transfering big data from local table to Odbc table on HostGator myPhpAdmin database

Well...finally I found the fastest way how to transfer data from local Access table to ODBC connected table. First I export data to Excel, then from Excel I exported to OpenDocument Spreadsheet, then Import as OpenDocument Spreadsheet into ODBC table..it need only few seconds...Thanks to all...

In Access there is an Export to XML, I exported table to xml on desktop, in HostGator, MyPHPAdmin there id option Import from XML, I imported from XML, and it says succsesfully imported, but I cannot see where it is imported...and of course i first chek the table where it to be imported..I can...