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 |
|
jmcbride
Starting Member
24 Posts |
 Posted - 2003-06-10 : 16:00:48
|
| Unfortunetly, an MS Word generated calendar was used for the approval process of our upcoming year's events. Rather than have to re-keystroke this information, ideally we could just import it some how. Are there any suggestions on how best to approach this task?--------------------http://www.utsa.edu/(Joe) Joseph McBride |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-06-10 : 16:22:31
|
| Never heard of it...can it be saved as a simple text file?Brett8-) |
 |
|
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2003-06-10 : 16:33:26
|
| Your best bet would be to access this via the Word API through VB. I assume the Word API makes this available to you, and if so, you can then use VB to parse it out and store it in the database.***************************************Death must absolutely come to enemies of the code! |
|
|
|
jmcbride
Starting Member
24 Posts |
Posted - 2003-06-10 : 16:33:43
|
| If you create a new Word doc, often you will be prompted with a help window that contains numerous tabs. On the "Other Documents" tab there is a Calendar wizard. This calendar was created through this.--------------------http://www.utsa.edu/(Joe) Joseph McBride |
|
|
|
jmcbride
Starting Member
24 Posts |
Posted - 2003-06-10 : 16:35:10
|
| I am not familiar with the Word API. How can I access this? Is it what consists of MACROS?--------------------http://www.utsa.edu/(Joe) Joseph McBride |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-06-11 : 08:54:15
|
| Seems like this thread should be in MS Access forum....No API mean Application Programming Interface....You can "call" it to program with objects...Brett8-) |
|
|
|
jmcbride
Starting Member
24 Posts |
Posted - 2003-06-12 : 09:32:45
|
| Any URLs where I can get more information?--------------------http://www.utsa.edu/(Joe) Joseph McBride |
|
|
|
|
|
|
Importing Data from Microsoft Word Calendar