cancel
Showing results for 
Search instead for 
Did you mean: 

importing data from Access table to Mysql

N/A

importing data from Access table to Mysql

Help someone please
I have a table in Access which has 750 odd rows.
I want to put this information into my database on crofters, without manually adding them one by one
Does anyone know how to do this?
I have a csv file that could be imported if I knew how or
Does anyone have a PHP script that will do the job for me?
Good with databases but novice on programming
Any info most welcome
--
Gina
4 REPLIES
N/A

RE: importing data from Access table to Mysql

Hi,

Try having a look at the following site, this should help you The full suite of mysql applications are installed on crofters so anything listed there will work:

http://www.mysql.com/doc/en/mysqlimport.html

Kind Regards,
Duncan.
N/A

RE: importing data from Access table to Mysql

Gina,

I will write a script for you if you like. A php script that will take the accesslines to mysql, or I will certainly give it a go.

Email me if I can be of assistance.

Chris.
info@cjtm.co.uk

> Help someone please
> I have a table in Access which has 750 odd rows.
> I want to put this information into my database on crofters, without manually adding them one by one
> Does anyone know how to do this?
> I have a csv file that could be imported if I knew how or
> Does anyone have a PHP script that will do the job for me?
> Good with databases but novice on programming
> Any info most welcome
>
> --
> Gina

N/A

RE: importing data from Access table to Mysql

I found this little script for access a while back that works exceptionally well, all you do is run it, then import the files into mysql using the mysql -u USERNAME -p MYDATABASE < DATAFILE
command via telnet

The url for the script is:

http://www.cynergi.net/exportsql/

make sure you read the FAQ before using it if you've never run an access module before otherwise it's very straightforward to run

The actual script can be got from:

http://www.cynergi.net/exportsql/exportsql2b.txt
N/A

RE: importing data from Access table to Mysql

Thanks everyone, with help from you guys I might get something going soon
Gina