importing username and passwords from a text file [tab delimited]

[garethj]

i need to import usernames and passwords from a text file [tab delimited] into a mysql user/pass table. is there a quick way to do this? where it can be automated and performed on a daily basis?

I currently have user names & passwords on a MS Access database - i can export this list and generate a text file w/ 2 columns [username & passwrd]

so, the question is how can i get this into an mysql db table?

thanks for any help you have.

g.

[Ph0eniX]

You can install the MyODBC driver on the machine running MS Access and link a new table in that DB to your MySQL table through a DSN, then just write a query that will select from one table and insert into the MySQL one. Have a macro execute the query as ofter as you need to run it. Should work.