willard Posted February 21, 2004 Posted February 21, 2004 Is the a way to copy or get a report to put into excel so I can use excel to work with my orders? I am getting so many orders , its hard to go 1 by 1 online to copy the info and place into excel. I sure hope I explained this right, I am going crazy try to figure out a way to do this, Thanks
ptrau Posted February 21, 2004 Posted February 21, 2004 First of all, congratulations!!! You have what we call a "Class A" headache....so many orders that they are hard to keep up with. That's a good one to have. Second, it can be done but it's not as easy as just downloading a file. If you have any Access experience, you can create a database that can handle what you need. You would export the seven(7) "Orders" tables in the "CSV for Ms Excel data" format(easiest to so if you use phpMyAdmin 2.5.2-pl1 as your mysql client). Once you have exported the tables you can import them into Access. Once your tables exist in Access you would then join the tables by "orders_id". Once you have done that you can create all types of forms, reports and crosstabs that can give you all types of information. Now that I have said all that, I realize that we could use the same thing as our business grows. I will knock the rust of mu Access skills and will give it a try. If I come up with anything worthwhile, I will let you know. It will be a welcome distraction for a couple of hours. "Aliiiiive, it's alive, it's ALIIIIIIIIIIIIIVE!!!"
ptrau Posted February 21, 2004 Posted February 21, 2004 OK...now this has gotten deep. A search has turned up this solution MySql to Access and I am digging into it. Check it out. "Aliiiiive, it's alive, it's ALIIIIIIIIIIIIIVE!!!"
ptrau Posted February 21, 2004 Posted February 21, 2004 Well I didn't get far. Installing the application went fine but when I try and import or link tables I get an error saying my db server doesn't exist....when if course it does. If anyone get's this to work, please let me know. Meanwhile, I will keep looking. "Aliiiiive, it's alive, it's ALIIIIIIIIIIIIIVE!!!"
Guest Posted February 21, 2004 Posted February 21, 2004 Worked fine for me on my local PC, are you trying to connect to an online server. Sounds like you have put the wrong server name, hostname or database name in the fields during the install and connect procedure.
ptrau Posted February 21, 2004 Posted February 21, 2004 I have the client installed on my local pc and am connecting to the MySql server that drives my website via the Internet. All of the variables are correct it just doesn't like what I am trying to do. I will continue to research. "Aliiiiive, it's alive, it's ALIIIIIIIIIIIIIVE!!!"
Guest Posted February 22, 2004 Posted February 22, 2004 If your settings are right do you have a firewall running it might block the connection. Mine worked okay but my server is on my local PC as well as the client. Works great and is really worth the effort to get it going.
ptrau Posted February 22, 2004 Posted February 22, 2004 I didn't think of that. I just tried it though with the firewall disabled and it doesn't work. I am beginning to belive that my host only allows connections to the database from within the domain (i.e. phpMyAdmin). Some are like that. So I am going to look at automating the exports from MySql....it will be a pain to do it manually each time. "Aliiiiive, it's alive, it's ALIIIIIIIIIIIIIVE!!!"
Guest Posted February 22, 2004 Posted February 22, 2004 You could export the tables using phpMyadmin, download the files and import them onto a mysql database on your PC. Then setup Access to it there. Only thing is you would have to regularly keep the database up to date with the one online.
Guest Posted February 22, 2004 Posted February 22, 2004 Also found this link on installing and connecting to online database using Access or Excel Click Here to view.
ptrau Posted February 22, 2004 Posted February 22, 2004 thanks...I'll check it out. "Aliiiiive, it's alive, it's ALIIIIIIIIIIIIIVE!!!"
ptrau Posted February 22, 2004 Posted February 22, 2004 OK.....that would be better than trying to keep up with certain reports online. I just dowloaded MySql 4.0 and will install it. Wish me luck. I have never used anything other than my host's MySql. "Aliiiiive, it's alive, it's ALIIIIIIIIIIIIIVE!!!"
ptrau Posted February 22, 2004 Posted February 22, 2004 Well that's not going to work. I opened the 3.5 meg install doc that came with the MySql download and it has enough instructions to launch the space shuttle. I am a functional user of OSC but certainly not a programmer or server expert. The install was easy but I was hoping for some type of gui to configure it. It is really this complicated or am I missing something? Do I need a server running on my laptop? "Aliiiiive, it's alive, it's ALIIIIIIIIIIIIIVE!!!"
Guest Posted February 22, 2004 Posted February 22, 2004 I found a great tutorial the other day which gives step by step detail on installing Mysql, PHP, Apache and configure in Windows. Link is Here For All to Find B)
ptrau Posted February 22, 2004 Posted February 22, 2004 What the heck...you only live once...here goes "Aliiiiive, it's alive, it's ALIIIIIIIIIIIIIVE!!!"
ptrau Posted February 22, 2004 Posted February 22, 2004 thanks so much...the last link gave a very clear set of instructions. Installed Apache and found MySql gui.... "Aliiiiive, it's alive, it's ALIIIIIIIIIIIIIVE!!!"
ptrau Posted February 22, 2004 Posted February 22, 2004 smooth as a babies behind...udaman "Aliiiiive, it's alive, it's ALIIIIIIIIIIIIIVE!!!"
ptrau Posted February 22, 2004 Posted February 22, 2004 Unbelievable...in 1.5 hours I have installed and have running on my local machine: php4 mysql apache phpmyadmin All of this because I just wanted to run a mysql-to-access application. I can now work on my websites offline as a testbed. I am sure everyone else already knew this. That tutorial is the coolest thing out there. Thanks again "Aliiiiive, it's alive, it's ALIIIIIIIIIIIIIVE!!!"
Guest Posted February 23, 2004 Posted February 23, 2004 Now you can play till your hearts content but don't forget to, backup, backup backup B) :rolleyes:
Recommended Posts
Archived
This topic is now archived and is closed to further replies.