By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,921 Members | 1,321 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,921 IT Pros & Developers. It's quick & easy.

Exporting fields from Access DB to LDIF file

P: n/a
Hello all,

I think Access is the tool I need for this but I'm having a little
trouble figuring out the best way to accomplish.

We are converting a lot of aliases (from a sendmail alias file) over to
distribution lists in Exchange. I have the alias entries in an Access
database, in the format

1 - aliasname1 - name1 - name2 - name3 - etc.

Each record begins with the name of the alias, then the member names in
subsequent fields after that. The records are all variable length,
depending on the number of usernames.

My goal is to parse and export this to an LDIF file, which will be
later imported into active directory with LDIFDE. Fortunately I'm
familiar with the layout of the LDIF file so I know how I'll need the
file formatted.

Can anyone offer any suggestions on a good way to do this with Access?
(I'm still quite new with Access and VBA, but, do have a basic
understanding of sql)

Thanks!
MJ

Jan 12 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Baz
So the format of the file you want exported is....?

"Maurice" <ma********@gmail.comwrote in message
news:11********************@v45g2000cwv.googlegrou ps.com...
Hello all,

I think Access is the tool I need for this but I'm having a little
trouble figuring out the best way to accomplish.

We are converting a lot of aliases (from a sendmail alias file) over to
distribution lists in Exchange. I have the alias entries in an Access
database, in the format

1 - aliasname1 - name1 - name2 - name3 - etc.

Each record begins with the name of the alias, then the member names in
subsequent fields after that. The records are all variable length,
depending on the number of usernames.

My goal is to parse and export this to an LDIF file, which will be
later imported into active directory with LDIFDE. Fortunately I'm
familiar with the layout of the LDIF file so I know how I'll need the
file formatted.

Can anyone offer any suggestions on a good way to do this with Access?
(I'm still quite new with Access and VBA, but, do have a basic
understanding of sql)

Thanks!
MJ

Jan 13 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.