Export/Import with MS Access

[huffmancs]

I would like to be able to export my SQL database to access to maintain and then import back into SQL. Can this be done. I have found exporting feature on the phpMyAdmin, but I do not see any import functions. The final result is I want to edit and maintain my database on my PC instead of a web based interface. Is there anyway to do this?

 

Thanks,

Kevin

[MarcoZorro]

you can import csv files into phpmyadmin....

 

I wouldnt use access though as its crap :P

[huffmancs]

Is there an interface other than the web interface that I can use to edit the data that will keep the links among the table. What would you recomend using? Where in phpMyAdmin does it allow you to import? I didn't see an import function, only an export.

 

you can import csv files into phpmyadmin....

 

I wouldnt use access though as its crap :P

[ecoren]

I would like to be able to export my SQL database to access to maintain and then import back into SQL. Can this be done. I have found exporting feature on the phpMyAdmin, but I do not see any import functions. The final result is I want to edit and maintain my database on my PC instead of a web based interface. Is there anyway to do this?

 

Thanks,

Kevin

 

u may try the mysql odbc connector, download it from mysql.com...

[♥Vger]

The final result is I want to edit and maintain my database on my PC instead of a web based interface. Is there anyway to do this?

 

The answer has to be "No", if you are trying to sync your offline database with your online database - so that the offline one automatically updates the online one. The reason is that you wouldn't be given access through the server firewall to alter the contents of the online database from your computer. The only exception to this would be if you had a dedicated ip address for your internet connection and your hosting company agreed to set that ip address up as a 'Remote User' on their system - but most companies won't allow this - for obvious security reasons.

 

If you just want to keep a copy of your online database on your local computer then set up your computer as a local web server and maintain a working copy of your website offline - complete with MySQL, thus avoiding the need to use Access at all.

 

You COULD install Easy Populate on your website, and then use that in conjunction with your offline website (also with Easy Populate installed to take a feed from your website offline and create an Easy Populate file) and then upload that file - and this will update your online database, but it will be initiated from your website and not from your computer.

 

Vger

[huffmancs]

The answer has to be "No", if you are trying to sync your offline database with your online database - so that the offline one automatically updates the online one. The reason is that you wouldn't be given access through the server firewall to alter the contents of the online database from your computer. The only exception to this would be if you had a dedicated ip address for your internet connection and your hosting company agreed to set that ip address up as a 'Remote User' on their system - but most companies won't allow this - for obvious security reasons.

 

If you just want to keep a copy of your online database on your local computer then set up your computer as a local web server and maintain a working copy of your website offline - complete with MySQL, thus avoiding the need to use Access at all.

 

You COULD install Easy Populate on your website, and then use that in conjunction with your offline website (also with Easy Populate installed to take a feed from your website offline and create an Easy Populate file) and then upload that file - and this will update your online database, but it will be initiated from your website and not from your computer.

 

Vger

 

 

Vger,

 

This is Huffmancs and I am still on this topic. Here is exactly what I want to do. I have a catalog of over 900 pages. Each page is entered into OSCommerce as a product, showing a scanned in image of this page. All the products, part numbers, on that page are options, entered as attributes. I am dealing with thousands of attriubutes, most with different pricing. I just want to be able to edit my products and atrributes/options offline. Working on the web interface takes so long to bring things up. I even get bumped off the server for going over my allowable amount of queries.

 

I tried easy populate, but it didn't bring my attribute information down. From what I heard about it, I don't want to use in anyways. Maybe I am doing something wrong. My solution is to be able to download the MySQL database, make additions/changes and update prices, then upload the database back onto the web.

 

What are your solutions for this.

[♥Vger]

Already answered:

 

If you just want to keep a copy of your online database on your local computer then set up your computer as a local web server and maintain a working copy of your website offline - complete with MySQL, thus avoiding the need to use Access at all.

 

Vger

[huffmancs]

Already answered:

Vger

 

I did some research on it today. I got another box I will setup as the server and use it. I all want is to take the shop off-line, download the database, make changes, then upload the new database. It seems like a lot of work for the technology we have today. I may look into a dedicated server for my site. If I do the expanding I plan on. it will almost be necessary.

 

Do you have any suggestions before I start setting up a local server?

 

Thanks for your help. It is greatly appreciated. If there is anything I can do for you, let me know.