| Author |
Automating Data Extraction from an Access Database
|
|
| ccieToBe 2002-03-28, 12:44 pm |
| I have an Access database containing information about various people my company works with that I'd like to extract the email address from and output to a text file. Is there any way to automate this? My servers run FreeBSD and the workstations are a mixture of Windows 98, 2000 and XP PCs with MS Office 97 and Star Office 5.2 loaded. | |
| The VMS Kid 2002-03-28, 12:51 pm |
| You could possibly get it done with some VisualBasic, but not the way you would in UNIX. You would still have to execute it by hand. | |
| ccieToBe 2002-03-29, 7:42 pm |
| Thanks for the info. I've never used Visual Basic before. Would it be easy to pick up? Other then shell scripting my programming skills are weak. | |
| The VMS Kid 2002-03-29, 7:48 pm |
| It isn't called BASIC for nothing. It is simple, weak, and ugly. It deals with objects in Access but if you can do shell scripting, it shouldn't be much of a problem. You may need a reference book or something, since I haven't seen a lot of info about this on the web. Do you have to use Access? If you had MySQL or PostgreSQL you would be able to integrate it with your scripts a lot easier. | |
| ccieToBe 2002-03-29, 9:09 pm |
| The file that I want to grab the data from is an Access file. It's maintained by a part of the company that I don't work for (we just share some of our data) so I can't tell them to change it to another format. If there were some automated way to convert this data to another format I'd be open to doing that. | |
| The VMS Kid 2002-04-02, 1:07 pm |
| Access can export its files in the form of ASCII text, and I know you can deal with that. Would be easy to use awk to manage it however you like. But that requires a bit of effort on the part of the Accessers. | |
| ccieToBe 2002-04-03, 1:23 pm |
| Alright, I can get someone to do a few clicks each day. The database's interface already has a method for extracting all the email addresses to an ascii file with one click but I was hoping to automate that. It's not a big deal. Thanks for the info.
Hmmm, I just did a search for "VNCscript" to see if anything's out there and came up with this:
http://onegeek.org/~tom/software/th...ncscript.README
That might be just what I need. | |
| The VMS Kid 2002-04-03, 2:35 pm |
| Good luck. Wish I could have been more help. But you know Microsloth. |
|
|
|