Creating txt file from sql database - pls HELP

[rave007]

Dear All,

Good day!

I want to create a program that uses SQL as my database. The program will create a text file of all the Employee Record and save it to drive C or in any network drives. Meaning continuously until he reached the EOF of the database.

The txt format is:

dn: CN=Employee Name1
changetype: modify
replace: EmployeeNo
EmployeeNo: EmpNo. Value
-

dn: CN=Employee Name2
changetype: modify
replace: EmployeeNo
EmployeeNo: EmpNo. Value
-

Variables are Employee Name, & Employee Value.Thank you.

Regards,

rave007

[Killer42]

A few questions...

• What version of VB are you using?
• When you say SQL, do you mean any sort of SQL database, or do you mean Microsoft SQL Server, or what?
• What have you attempted so far? Few people here will be interested in doing the project for you, but we'll be happy to help if you get stuck.

[rave007]

Sorry for my late response, I thought it will automatically send me a notification. I'm using MS SQL and VB6.

Thanks again. I'm currently stuck and not yet started. And if possible, I'm also want to know if how can I disable my user in active directory if the user or employee is already terminated or resigned to my employee master table (ms sql) from our erp system.

Thank you again.

rave :)