#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2000
    Posts
    2
    Rep Power
    0
    I have an Access database of around 11,000 products that I am trying to import into MySQL and use PHP3 for search and dynamic display on webpages. Does anyone have any recommendations on how to achieve this somewhat gracefully? The server is Apache and PHP3 and MySQL are already intalled.
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 1999
    Location
    Ekaterinburg, Ural, Russia
    Posts
    10
    Rep Power
    0
    Hi, Rocky,
    My ancestor-sysadmin made this. Gracefully. All the circumstances were the same but we have PostgreSQL here. You should use ODBC for that. That guy told me that he had to enter some strings into WinNT registry manually, but I don't know exactly what was that. It worked. Probably I can find it in his huge archives. Email me if you want me to.
    =Thistle=
  4. #3
  5. No Profile Picture
    moderator
    Guest
    Devshed Newbie (0 - 499 posts)
    You might also want to look at mysqlimport that comes with mysql. You can import delimited files, it's quite flexibile.

  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2000
    Location
    The Netherlands
    Posts
    4
    Rep Power
    0
    Rocky,

    On the ws you have Access on, you might wanna install MyODBC (available at the MySQL site). It installs an ODBC driver which lets you connect to the MySQL server from you Access app. I noticed it will not work if you use Access 2000, but 97 works great.

Similar Threads

  1. SPs in Access 2000 (SQL) / Crosstab problem / returning dataset
    By michaeldallas in forum MS SQL Development
    Replies: 1
    Last Post: September 1st, 2005, 01:41 PM
  2. Records not added to MS Access db - why?
    By ywickham in forum Database Management
    Replies: 1
    Last Post: December 7th, 2003, 05:14 PM
  3. ms access - mySQL interaction question
    By alexmasters in forum MySQL Help
    Replies: 0
    Last Post: December 6th, 2003, 06:09 AM
  4. createObject Vs as New Keyword
    By imran189 in forum Visual Basic Programming
    Replies: 3
    Last Post: November 11th, 2003, 07:19 PM
  5. Linking Mysql and Access forms and reports
    By Prathmesh in forum MySQL Help
    Replies: 0
    Last Post: October 22nd, 2003, 11:15 PM

IMN logo majestic logo threadwatch logo seochat tools logo