Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lcannon
Starting Member
3 Posts |
 Posted - 2005-07-17 : 10:03:43
|
| Does anyone have suggestions on how to or the best way to search a directory in all .mdb's for tables that contain say field name "empnumber" and replace it with say "empID". I have searched several forums and internet and found a product called "Speed Ferret", but I would rather not use it but it may be too difficult to create on my on. If anyone has ideas or suggestions. Please post. |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2005-07-17 : 19:10:24
|
| Should be easy enough to do in VB or VBScript. I'm not going to give you the code to do it, but you should be able to do it yourself:- use the FileSystemObject to return a list of files in a given folder- for each of the files with the correct extension, build an ADO connection string for it (or use DAO - your choice)- iterate through each table to find the field name you're looking for.- use ADOX objects to modify the field names (DAO should also be able to help)It's not a trivial exercise, but it's certainly not rocket science. If you have a programming background it should be reasonably easy.HTH,Timbtw - and don't cross-post.... |
 |
|
|
sendoh
Starting Member
12 Posts |
Posted - 2005-07-20 : 03:45:42
|
| try this www.xtremevbtalk.comwww.vbcity.comdeep |
|
|
|
|
|
|
Directory search to find Field Names