#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2000
    Posts
    3
    Rep Power
    0
    I have a Database file or a table in MS Access, now I wanted to convert that into MySQL. Also I have these record in a text file. Can I get that records into mysql.
    Please help me as I am using MySQL/PHP for the first time..
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2000
    Posts
    7
    Rep Power
    0
    Hi,

    I haven't yet converted an Access DB to MySQL, but if you have a textfile you could simply use the MySQL command:

    LOAD DATA INFILE 'filename goes here' INTO TABLE 'tablename';

    Read the MySQL manual for further instructions on how to use LOAD DATA INFILE.
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2000
    Posts
    7
    Rep Power
    0
    You could also look at the Converters section in: http://www.mysql.com/Contrib/
    I've seen some Access --> MySQL converters.
    As I mentioned before, I've never done it, but if it worked for you, maybe you could explain how you did it?
  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2000
    Posts
    3
    Rep Power
    0
    Thanks for your reply.
    I suppose It will provide me great help in future as I have already done that by first converting access database to text file and then using command importsql I have converted it into MySQL table.
    I will try this also and whenever I complete this I will let you know.
    thanks again

    [This message has been edited by sanveer (edited April 22, 2000).]

Similar Threads

  1. Replies: 17
    Last Post: July 11th, 2004, 05:08 PM
  2. DIV scroll with image scroll buttons
    By CarlosFratini in forum HTML Programming
    Replies: 5
    Last Post: May 21st, 2004, 08:58 AM
  3. importing text file
    By min in forum PHP Development
    Replies: 12
    Last Post: November 26th, 2003, 04:18 AM
  4. problem: asp files, from access to mysql
    By karib1 in forum MySQL Help
    Replies: 1
    Last Post: November 26th, 2003, 03:16 AM
  5. Probs writing to existing text file...
    By grahamg in forum PHP Development
    Replies: 3
    Last Post: April 11th, 2001, 10:49 AM

IMN logo majestic logo threadwatch logo seochat tools logo