osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 
 

Importing from msAccess

This is a discussion on Importing from msAccess within the osCMax v1.7 Discussion forums, part of the osCMax v1.7 Forums category; I've not tried yet this, but: Does some1 know a way to import the articles contained in a msAccess db ...


Go Back   osCommerce and osCMax shopping cart software forums > osCMax v1.7 Forums > osCMax v1.7 Discussion

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Closed Thread

 

LinkBack Thread Tools
  #1  
Old 04-16-2004, 09:28 AM
Member
 
Join Date: Apr 2004
Location: Argentina
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
damnedpig
Default Importing from msAccess

I've not tried yet this, but:
Does some1 know a way to import the articles contained in a msAccess db to the oscommerce (or osC MS2-MAX) DB ?
Thanks in advance. Hope your help.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Advertisement
  #2  
Old 04-16-2004, 11:19 AM
jpf's Avatar
jpf jpf is offline
Moderator

 
Join Date: Sep 2003
Location: Manitoba, Canada
Posts: 1,684
Thanks: 2
Thanked 94 Times in 80 Posts
Rep Power: 12
jpf is a glorious beacon of lightjpf is a glorious beacon of lightjpf is a glorious beacon of lightjpf is a glorious beacon of lightjpf is a glorious beacon of lightjpf is a glorious beacon of light
Default

Yes - Comma Separated Values or CSV format. Access can IMPORT/EXPORT in this format.

Then using the EasyPopulate(EP) contrib (included in MAX) to export data and reimport it.

Note: EP normally only works with the item numbers. If your looking to import "other" things then use your MySQL admin tool (like phpMyAdmin) to export any table in CSV format then edit/modify in Access then re-export - then import back into your OSC database. Always do this on a backup TEST site first!
Consult the PDF (that is included with MS2 and MS2-MAX archive files) for the database table and what is linked with what - just incase there are other entries that have to be made in other tables....

Good luck
__________________
JPF - osCMax Fourm Moderator
Try out our osCMax at: Live Catalog Demo
Limited access Admin: Live Admin Demo
Feel free to add products they way you want and then purchase them -=+=- Sorry nothing will be billed or shipped!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Advertisement
Closed Thread

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
Installed and upgrading from osc 2 database needs importing gamefreak7 osCMax v2 Installation issues 4 07-17-2005 10:31 AM
Importing Database and installing contribution kashifk osCommerce 2.2 Installation Help 0 08-31-2004 05:39 PM
Importing data with Easypopulate michael_work2003 osCMax v1.7 Discussion 8 03-27-2004 12:30 AM
zones not importing - strange error Rodland osCommerce 2.2 Modification Help 2 03-09-2003 04:31 AM
Importing .SQL file Anonymous osCommerce 2.2 Installation Help 3 11-08-2002 05:54 AM


All times are GMT -8. The time now is 12:52 AM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
http://www.oscmax.com/forums/
Copyright 2008 osCMax