WampServer

Hello Guys,

i am looking for a technique or method where my excel is connected with wamp server & every time when i update the date in excel that will be reflects on wamp server. please suggest me.

what are you talking about!

this is too vague..


what gets updated in wamp?

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

yup, what every i update in excel that should me updated in wamp sql database.

Oh excel to MySQL

Yes it's possible but it's not a wamp thing.

You will need to write an excel VBA MACRO
that when you save the work , runs , connect to MySQL running on port 3306 and imports
All the data you want.

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

bingo , could you guide me or you have any example that i can study and create the MACRO thing

here you go

[www.heritage-tech.net]


but first you might need to learn the basics of writing VBA code into excel which you will find lots of tutorials online

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Hay Steven Thanks