import database

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
aisha_shahbaz
Forum Newbie
Posts: 5
Joined: Tue Nov 04, 2008 1:21 am

import database

Post by aisha_shahbaz »

hi expert
i want to import the north wind datbase of traders from microsoft access but here is error in phpmyadmin
error is like "check manual ......... "how i will import i think it is problem during eport database from access
plz help me
User avatar
infolock
DevNet Resident
Posts: 1708
Joined: Wed Sep 25, 2002 7:47 pm

Re: import database

Post by infolock »

how did you export the table from access? is it a CSV file? also, what is the exact error that you are getting?
aisha_shahbaz
Forum Newbie
Posts: 5
Joined: Tue Nov 04, 2008 1:21 am

Re: import database

Post by aisha_shahbaz »

first i make dab with .mdb extension on desktop-> i click on table in access then click export and give path to db of desktop click definition and data in dialog box and click ok
now i want to import it in phpmy admin by browsing
then it gives error of check manual like error
User avatar
infolock
DevNet Resident
Posts: 1708
Joined: Wed Sep 25, 2002 7:47 pm

Re: import database

Post by infolock »

if all you are dealing with is data, and all you are trying to import is data, just dump from access to a CSV file and import that file.

if it doesn't work, please post the EXACT error you are getting.

If you are not only dumping data into a table but also trying to create the table from an access dump, then yeah it's probably going to error out as access != mysql. i don't think this is what you are trying to do, but just in case it is, you should know you'll probably have to manually recreate the table schema.
aisha_shahbaz
Forum Newbie
Posts: 5
Joined: Tue Nov 04, 2008 1:21 am

Re: import database

Post by aisha_shahbaz »

sir i want to export the data and definition both from microsoft access(northwind database) let me know how so that i can import in phpmyadmin
thx in advance
Post Reply