List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:June 30 1999 4:48pm
Subject:Re: convert access data to mysql data ?...
View as plain text  
"Mr. B.HARI" wrote:
> 
> 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
> 

Your privilege system is not properly configured. Make sure to read the
sections of the manual (#6 I believe) on the privilege system.

-- 
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)
Thread
convert access data to mysql data ?...Mr. B.HARI30 Jun
  • Re: convert access data to mysql data ?...Sasha Pachev30 Jun