CompTIA
Exam Vouchers
Save money on CompTIA exams
| Question of the day
Sign up to receive
interactive practice questions
for MCSE, CompTIA
Cisco and other exams
| TestKing
Get MCSE, MCSD, CCNA, CCNP,A+, N+ and many more | * ExamSheets *
Guide for Success!
Actual Questions & Answers
MCSE, MCSD, A+ ,CCNA, CCNP
Oracle 8i, Oracle 9i Online practice tests
Certification sites Online university Online college Online education Distance learning Software forum Server administration forum Programming resources
|
|  |
| Author |
Automating Data Extraction from an Access Database
|
ccieToBe
Wireless Fanatic
Registered: Jul 2000
Location: Blue Ridge, North Georgia
Country: US
State:
Certifications: CCDA, CNA, MCP, Network+, A+, BSIT
Working on: Security+
Total Posts: 2210
|
|
 Automating Data Extraction from an Access Database
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.
Report this post to a moderator
|
|
 03-28-02 05:44 PM
|
|
The VMS Kid
DecHead
Registered: Feb 2002
Location: Beer
Country: United States
State:
Certifications: Network+, i-Net+, A+, Linux+, CST
Working on: Beer
Total Posts: 1009
|
|
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.
Report this post to a moderator
|
|
|
03-28-02 05:51 PM
|
|
ccieToBe
Wireless Fanatic
Registered: Jul 2000
Location: Blue Ridge, North Georgia
Country: US
State:
Certifications: CCDA, CNA, MCP, Network+, A+, BSIT
Working on: Security+
Total Posts: 2210
|
|
|
|
03-30-02 12:42 AM
|
|
The VMS Kid
DecHead
Registered: Feb 2002
Location: Beer
Country: United States
State:
Certifications: Network+, i-Net+, A+, Linux+, CST
Working on: Beer
Total Posts: 1009
|
|
|
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.
Report this post to a moderator
|
|
|
03-30-02 12:48 AM
|
|
ccieToBe
Wireless Fanatic
Registered: Jul 2000
Location: Blue Ridge, North Georgia
Country: US
State:
Certifications: CCDA, CNA, MCP, Network+, A+, BSIT
Working on: Security+
Total Posts: 2210
|
|
|
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.
Report this post to a moderator
|
|
|
03-30-02 02:09 AM
|
|
The VMS Kid
DecHead
Registered: Feb 2002
Location: Beer
Country: United States
State:
Certifications: Network+, i-Net+, A+, Linux+, CST
Working on: Beer
Total Posts: 1009
|
|
|
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.
Report this post to a moderator
|
|
|
04-02-02 06:07 PM
|
|
ccieToBe
Wireless Fanatic
Registered: Jul 2000
Location: Blue Ridge, North Georgia
Country: US
State:
Certifications: CCDA, CNA, MCP, Network+, A+, BSIT
Working on: Security+
Total Posts: 2210
|
|
|
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.
Report this post to a moderator
|
|
|
04-03-02 06:23 PM
|
|
The VMS Kid
DecHead
Registered: Feb 2002
Location: Beer
Country: United States
State:
Certifications: Network+, i-Net+, A+, Linux+, CST
Working on: Beer
Total Posts: 1009
|
|
|
|
04-03-02 07:35 PM
|
|
|
Featured site: MCSE, MCSD, CompTIA, CCNA training videos
Forum Rules:
Who Can Read The Forum? Any registered user or guest.
Who Can Post New Topics? Any registered user.
Who Can Post Replies? Any registered user.
Changes: Messages can be edited by their author.
Posts: HTML code is OFF. Smilies are ON. vB code is ON. [IMG] code is ON. |
|
ExamNotes forum archive
|
