Page 1 of 1

import database

Posted: Tue Nov 11, 2008 11:13 pm
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

Re: import database

Posted: Tue Nov 11, 2008 11:17 pm
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?

Re: import database

Posted: Tue Nov 11, 2008 11:39 pm
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

Re: import database

Posted: Wed Nov 12, 2008 9:29 am
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.

Re: import database

Posted: Wed Nov 12, 2008 9:54 pm
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