Unable to export Outlook 2007 data to Excel or Access

Status
Not open for further replies.
J

JW5

I am trying to export my calendar and contacts from Outlook 2007 to Excel or Access. I go through the Import/Export wizard, select " Export to a file" , select either Excel or Access, and specify a file name and location, but I then get the following error message:

Translation Error...ODBC Driver Manager...Data source name not found and no default driver specified.

Are there ODBC drivers missing that need to be installed? How do I fix this problem? I tried exporting to comma delimited and tab delimited file formats, but my data does not export correctly, probably due to embedded carriage returns in the data.
 

Karl Timmermans

Senior Member
Outlook version
Outlook 2013 32 bit
Email Account
POP3
#1 - Outlook tab-delimited files do not play well with the rest of the world including Excel and Access when " multi-line" fields (such as address, body etc) are involved. Experience with Outlook tab-delim files is that these are problematic and from the tests we ran - the only MS product that can deal with an Outlook generated tab delim file is Outlook itself (ContactGenie products had to be modified to deal with multi-line field tab-delim files specifically created by Outlook). Really no reason to ever select " tab-delimited" unless that is the ONLY option available in whatever program is ultimately going to use the file which would be a rare circumstance. (For those who care about technical trivia - issue stems from/relates to the field " text qualifier" characters).

#2 - MS generated CSV files and handling of same has to be one of the most reliable of anything out there. Can't recall any kind of CSV file generated by Outlook that wasn't handled correctly by Excel or Access regardless of what kind of fields are involved (including the exact same data used to create a tab-delim file which has problems). So to that end - assuming there are no driver issues involved - question becomes:

" in reference to the CSV file exported - what do you mean exactly when stating that data does not export correctly?"

When exporting multi-line fields to Excel or Access - these will " appear" to be incomplete since there are embedded line breaks in the field and the data is not fully visible until the field is expanding in either the Excel or Access user-interface.

#3 - As for the translation error - what is the <complete> error message that is displayed?
 
R

rjkats

I am having a similar problem - trying to import contacts from Outlook 2007 to Access 2007 -
error message reads: can't overwrite table or query " contacts"

When I first tried I chose the option to link the programs and didn't get anywhere before I got the error message, so I went back & unchecked that and got to the point to choose the access primary key and it showed my partial contacts in table form. When I clicked next it went to the " finish" screen. when I hit finish it gives me the same error.

If I try to do it by exporting from Outlook to Access, access is looking for an .mdb file which I made by exporting from Outlook but the option is Access 97-2003 (- none for 2007). When I select this & try to open it nothing has transferred.
 

Karl Timmermans

Senior Member
Outlook version
Outlook 2013 32 bit
Email Account
POP3
In reference to no .accdb (Access 2007) option when exporting from Outlook to Access - that's correct - there is no option for Excel .xlsx or Access .accdb formats - whether '2007 or '2010. BCM on the other hand does support those formats in its import/export functionality which is an entirely different import/export process from standard Outlook.

In reference to nothing being transferred when exporting from Outlook - did you manually " map" the fields to ensure that there were fields selected for export?

In reference to importing Outlook contacts into Access
- from the error message - sounds like there is something in your Access database that is preventing a pre-existing contacts table from being deleted. Did you try this from an empty Access database or one that already had tables in it (perhaps a contacts table that was already <linked> to Outlook)
- have very seldom used the Outlook to Access mode via Access - have never been able to get the <import> function to work when a contact folder involved. Link to a contact table has never been an issue but importing to a table has been a problem so perhaps someone with more MS Access experience may be able to shed some light on that aspect of the <Access> import process which is completely different from exporting from Outlook to Access.
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
C Locked out of MS Outlook 2010 Trial Version - unable to export messages to Windows Live (Windows 7) Using Outlook 1
A Unable to export contacts to PST in Outlook 2007 with Win 7 Ultimate (64 bit) Using Outlook 4
T unable to export a particular folder Using Outlook 2
A Unable to archive PST or export to PST --- issue is the same with Office 2003 & 2007 using Win 7 Ul Using Outlook 3
A Unable to save recurring Meeting to Documents folder due to error Using Outlook 2
O Outlook 365 - suddenly unable to send using Gmail POP3 Using Outlook 10
S Outlook 2010 unable to change default font Using Outlook 7
Q Unable to Sync Quicken reminder with Outlook 2016 64Bit Using Outlook 1
S Unable to remove rule outlook 2010 Using Outlook 0
L Wierd Office 365 Contact unable to edit body of random contacts Using Outlook 5
X Unable to send an email from one account to another on same PC Using Outlook 2
Mark Foley Unable to subscribe to published calendar in Outlook 2010 Using Outlook 4
S Unable to Edit Contact Information in Certain Contact Folders Using Outlook 3
P Deleted Items - Unable to Iterate All of Items Outlook VBA and Custom Forms 1
G Unable to dismiss reminders from share point list calendar shared in Outlook Using Outlook 2
R Unable to install without email account Using Outlook 4
E Unable to open Outlook 2010 after adding new email account Using Outlook 4
A Outlook 2016- unable to have all subfolders expanded when opening outlook Using Outlook 11
avant-guvnor Unable to view certain emails in Outlook 2016 Using Outlook 16
M Unable to Configure Gmail Account in Outlook 2007 Using Outlook 1
D Unable to Send On Behalf of Another User Exchange Server Administration 0
J Unable to link email messages in BCM using a single microsoft office 365 account in outlook 2013 BCM (Business Contact Manager) 1
Tim King Outlook 365 unable to change accounts Using Outlook 0
R Unable to send mail using Cox.net Using Outlook 1
T Unable to 'Upload a file' using popup 'Browse' button Using Outlook 0
D Unable to add email address to contact Using Outlook 3
G Outlook calendar entry corrupted. Constant pop up when you open outlook. Unable to delete or remove. Using Outlook 2
O OL2000: Unable to create IMAP account Using Outlook 2
wallisellener Unable to reply/post/create new thread using Chrome BCM (Business Contact Manager) 5
Rupert Dragwater unable to change font sizes in some replies Using Outlook 3
C Unable to see meeting attendees Outlook 2010 Using Outlook 5
M Unable to email from Word or Excel Using Outlook 11
O Unable to check name. Using Outlook 3
T Unable to create contacts subfolder in EAS profile Using Outlook.com accounts in Outlook 6
UncleBill Unable to delete items from gmail IMAP Trash using Outlook 2010 Outlook VBA and Custom Forms 5
B Unable to search delegated mailfile Using Outlook 3
K Unable to activate QueryBuilder in Outlook 2010 (32bit) with Windows 7 (64bit) Using Outlook 1
C Unable to forward email with URL Using Outlook 2
R New computer, OL2010 unable to display shared calendar appointments Exchange Server Administration 3
S unable to send email from my second address (outlook 2007) Using Outlook 2
A "Unable to display the folder" error when accessing Group mailbox Using Outlook 0
C Outlook 2010, two exchange mailboxes configured.Unable to see 2ndrymeeting req Using Outlook 2
H Outlook 2010 unable to send iCloud account e-mail after iOS 7 upgrade Using Outlook 12
B Unable to apply rule on Exchange server functional account Exchange Server Administration 1
J Archives: Unable to locate emails Using Outlook 1
S Unable to send or reeceive email in new Exchange 2010 Exchange Server Administration 0
B Unable to Accept meetings that are already Tentatively accepted Using Outlook 2
M Unable to read HTML Using Outlook 2
A Unable to send with attachments in Outlook 2013 (Exchange ActiveSync) Using Outlook 2
F Outlook 2010 unable to delete emails from scanner Using Outlook 1
Similar threads


















































Top