List:General Discussion« Previous MessageNext Message »
From:Mr. B.HARI Date:July 3 1999 11:37am
Subject:convert access data to mysql data ?...
View as plain text  
Dear  Sir,

We have access database.
Now our objective is  to load these tables  as mysql  tables   in to
MYSQL  SERVER
We have tried several  methods    but could not do it?

In our local NTSERVER  we could able to convert access to mysql table
in the follwing ways.

I) converted  the  access files into text files

II) LOAD DATA INFILE “c:\\textfile” INTO TABLE “mysql table name” is
command used
  for storing text files into mysql files.
III) they were stored  in the   local NTSERVER/DATA directory.


But same thing we could not do  for  mysql  SERVER   our ISP is
Communitech,  our server  is  mars

I am facing an error “access denied to username@localhost “

Please let us know how to  store data?

Bharadwaj
Thread
• convert access data to mysql data ?...Mr. B.HARI30 Jun
  • Re: convert access data to mysql data ?...Sasha Pachev30 Jun