Go Back   Access World Forums > Apps and Windows > SQL Server

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-08-2019, 04:49 AM   #1
NauticalGent
Pristine Curmudgeon
Gold Supporter
 
NauticalGent's Avatar
 
Join Date: Apr 2015
Location: Naples, Italy (EXPAT from Virginia)
Posts: 2,012
Thanks: 447
Thanked 299 Times in 258 Posts
NauticalGent has a spectacular aura about NauticalGent has a spectacular aura about
T-SQL to copy contents of OutLook Folder

Good afternoon AWF...

I am having issues getting the contents of an Outlook folder into my Access(SQL BE) tables. Long story and it isn't that big of a deal but I was wondering if it is possible to do from stored procedure in SQL.

I am confident it is but I am unsure of the syntax...

Has anyone here done anything like this?

__________________
It follows then as certain that night succeeds the day, that without normalization, we can do nothing definitive, and with it, everything honorable and glorious. - with apologies to George Washington
NauticalGent is offline   Reply With Quote
Old 11-08-2019, 07:08 AM   #2
sonic8
AWF VIP
 
Join Date: Oct 2015
Posts: 269
Thanks: 43
Thanked 76 Times in 73 Posts
sonic8 is on a distinguished road
Re: T-SQL to copy contents of OutLook Folder

Quote:
Originally Posted by NauticalGent View Post
I was wondering if it is possible to do from stored procedure in SQL.
Nope! - T-SQL runs inside SQL Server and there is (almost) no option to communicate to the outside world.
The options that do exist (xp_cmdShell, CLR-Integration) are usually restricted.
__________________
New article:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
sonic8 is offline   Reply With Quote
The Following User Says Thank You to sonic8 For This Useful Post:
NauticalGent (11-08-2019)
Old 11-08-2019, 07:31 AM   #3
NauticalGent
Pristine Curmudgeon
Gold Supporter
 
NauticalGent's Avatar
 
Join Date: Apr 2015
Location: Naples, Italy (EXPAT from Virginia)
Posts: 2,012
Thanks: 447
Thanked 299 Times in 258 Posts
NauticalGent has a spectacular aura about NauticalGent has a spectacular aura about
Re: T-SQL to copy contents of OutLook Folder

Thanks Sonic8, I was hoping for a different answer but at least now I can stop chasing my tail!

__________________
It follows then as certain that night succeeds the day, that without normalization, we can do nothing definitive, and with it, everything honorable and glorious. - with apologies to George Washington
NauticalGent is offline   Reply With Quote
Old 11-08-2019, 08:26 AM   #4
theDBguy
Im here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,783
Thanks: 57
Thanked 1,267 Times in 1,248 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: T-SQL to copy contents of OutLook Folder

Just trying to help, but would there be anything useful here? Either that or they may be third-party add-ins for doing something like that.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 11-08-2019, 08:56 AM   #5
NauticalGent
Pristine Curmudgeon
Gold Supporter
 
NauticalGent's Avatar
 
Join Date: Apr 2015
Location: Naples, Italy (EXPAT from Virginia)
Posts: 2,012
Thanks: 447
Thanked 299 Times in 258 Posts
NauticalGent has a spectacular aura about NauticalGent has a spectacular aura about
Re: T-SQL to copy contents of OutLook Folder

Hello the DBG, I did see that article and I wasn’t sure if it was what is was looking for. I guess I could try and fumble around, I just might get lucky.

As to 3rd party add-in’s, our IT is a contracted entity who, because of restrictions imposed my the DoD, have us on complete lock-down. Only approved software gets installed and it takes an act of God to get something approved and I doubt if even He would have that kinda juice!
__________________
It follows then as certain that night succeeds the day, that without normalization, we can do nothing definitive, and with it, everything honorable and glorious. - with apologies to George Washington
NauticalGent is offline   Reply With Quote
Old 11-08-2019, 09:00 AM   #6
theDBguy
Im here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,783
Thanks: 57
Thanked 1,267 Times in 1,248 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: T-SQL to copy contents of OutLook Folder

Hi John. Good luck! I know what you mean. Working for the DoD can be a pain. I should know since I have to deal with it everyday. Cheers!

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Create a new folder and copy another folders contents into the new folder Rob_Jones101 Forms 8 08-08-2019 03:52 AM
VBScript copy file to folder then cut it and past it in another folder Alhakeem1977 Visual Basic 7 06-24-2019 03:30 AM
Copying folder contents into a Dictionary kirkm General 6 08-24-2016 03:09 PM
Question Can The Contents Of A Folder Be Displayed? Groundrush General 2 12-07-2010 12:14 AM
Emailing contents of folder jfgambit Modules & VBA 4 08-22-2008 11:20 PM




All times are GMT -8. The time now is 06:14 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World