Hello Friends I have A Excel Work Book On My Pc i want to export its data to my web server of www.seedtofeed.co.cc and that should transfer in seconds so any one help me how can i export SERVER CONFIG cPanel Version 11.24.5-STABLE cPanel Build 38506 Theme x3 Apache version 2.2.13 (Unix) PHP version 5.2.11 MySQL version 5.0.81-community Architecture x86_64 Operating system Linux Shared Ip Address 69.175.11.34 Path to sendmail /usr/sbin/sendmail Path to PERL /usr/bin/perl Kernel version 2.6.27.10-grsec
Use Navicat, you can import from Excel and about 30 other data types - http://www.navicat.com They have a free personal version, and a free 30 day trial.
Lets make sure we understand your question first ok so you are not looking to upload an Excel to the server one time. You want to keep the server in sync with the desktop excel? i.e. each time you add something to excel you want to be able to update the server automatically? Did I get that right?
yeah thats a bit tricky - but basically you can do one of 2 things I guess 1) each time excel is updated you can have somekind of a software to upload it to mysql ... that will get hairy fast, so dont think I would recommend it 2) Use Excel to connect to mysql directly using ODBC. its been years since I did ODBC stuff but I think the following website might help http://www.automateexcel.com/2005/11/01/connect_excel_to_mysql_database/ Fuji But then you can also ask yourself why you have a local excel if you want to update mysql. you can create a php script to update Mysql and display the data. But you know your business a lot better than I do