Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-30-2013, 10:24 AM
BobBridges's Avatar
BobBridges BobBridges is offline How to import excel calender data into outlook - with a click of a button Windows 7 64bit How to import excel calender data into outlook - with a click of a button Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Say, how did you export an appointment from Outlook's calendar, anyway? I just looked for it, and I don't see the way to do it.
Reply With Quote
  #2  
Old 09-30-2013, 11:14 AM
davesp davesp is offline How to import excel calender data into outlook - with a click of a button Windows 7 64bit How to import excel calender data into outlook - with a click of a button Office 2010 64bit
Novice
 
Join Date: Jan 2013
Posts: 17
davesp is on a distinguished road
Default

Bob, I attached an original export, except for an e-mail address I needed to mask.

As for the how, in 2010, clock on FILE, then OPEN, then IMPORT - silly place to put an export function, but the first 3 option are export... Choose export to a file....

One other thing. this site does not allow for CSV uploads so I had to save the file as an xls.... Not sure if that conversion does anything to the data but thought you should know.
Attached Files
File Type: xls Test Export.xls (22.5 KB, 20 views)
Reply With Quote
  #3  
Old 09-30-2013, 12:01 PM
BobBridges's Avatar
BobBridges BobBridges is offline How to import excel calender data into outlook - with a click of a button Windows 7 64bit How to import excel calender data into outlook - with a click of a button Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Ok, so now that I know how (thanks for showing me—and I agree, a silly place for doing exports, but I never looked further than File anyway, didn't think of Open much less Import), I tried exporting my own appointments to CSV.

Now, I notice you said you "confirmed the use, or in this case the non-use of quotes". Does that mean that in the CSV that you're trying to import back into Outlook, the email addresses (in column 11) do not have quotes around them? I'm being so specific because when I export my own appointments to CSV, there are email addresses in column 11; besides the header row there are two records, and in both appointments the email values are in double quotes. In the first there are multiple comma-separated addresses and some of them are names only, eg Bob Bridges (so I presume Outlook feels free to look them up in my contacts book), but others are email addresses; and in the other appointment the only entry is
Code:
...,"RBridges@infosecinc.com",...
...with the quotes. (That's my work address.) I infer that the quotes are necessary at import time. But you say you confirmed the non-use of quotes, so I'm suspicious.
Reply With Quote
  #4  
Old 09-30-2013, 02:02 PM
davesp davesp is offline How to import excel calender data into outlook - with a click of a button Windows 7 64bit How to import excel calender data into outlook - with a click of a button Office 2010 64bit
Novice
 
Join Date: Jan 2013
Posts: 17
davesp is on a distinguished road
Default

Crud - though you hit on something, but no luck.

I re-exported an appt with a required attendee. Openeded the CSV andthere are no quotes - single or double.

But, I went to my test import file, added double quotes and imported it. Still no luck. So I tried single quotes and no luck.

Have you attempted to import an appt with a required attendee?

I have asked this question over int he Outlook forum... so I guess I wait and see.

I wonder if there is some sort of policy or enterprize tyep rule preventing this...

Thanks

dave
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Query Text in MS-Excel 2010 or Import Data & Query outside of Excel? mag Excel 0 10-18-2012 11:15 AM
Import excel data in to SQL Server DavidBrown Excel 0 08-08-2011 04:49 AM
How to import excel calender data into outlook - with a click of a button Unable to sync iphone calender with outlook calender!! Reltub Outlook 5 07-26-2011 02:55 AM
Import Pics and Excel Data into PP? jawillyams PowerPoint 0 03-13-2011 01:03 PM
How to import excel calender data into outlook - with a click of a button Outlook data import Cunner Outlook 2 08-20-2010 02:03 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:46 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft