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
import database
Moderator: General Moderators
Re: import database
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
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
now i want to import it in phpmy admin by browsing
then it gives error of check manual like error
Re: import database
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.
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
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
thx in advance