MS 2007 / ACL error

[Trinh Tran]

Hi there,

I’m hoping some super user can help me out with this following error when I try to import Excel 2007 data file into ACL.  I have installed "2007 Office System Driver" is required to read data from 2007 but still get error. 
This was posted on User Forum:

Office system files such as MS Office Access and MC Office Excel on Windows XP
SP2 and higher.  The Drive can be installed from: http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

Any assistance would be greatly appreciated.  I’m an ACL novice.  Thanks! 

 

CONFIDENTIAL: The information contained in this email communication is confidential information intended only for the use of the addressee. Unauthorized use, disclosure or copying of this communication is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by return email and destroy all copies of this communication, including all attachments.

[Ryberg, Nicholas]

I recently had this problem (same version) and sidestepped the issue by exporting the data in tab delimited format to a new text file.  This would be worth a call to ACL support…

 

 

Nick Ryberg, CISA
(651) 855-5854

[Raabe, John J]

Hi all.

I, too, encountered this error (import of  Excel) in version 9.1  I spoke with tech support for some time and even tinkered with de-registering and re-registering system DLLs in windows to get this import to work.  In the end, we had to revert back to v9.0 to get back to a working solution on Allina PCs.  What I did learn from that experience is that the body of code defining the Excel import (data define) wizard was completely rewritten from v9.0 to v9.1.

 

You will find that the general user community of ACL dislikes Excel as an import file format when reviewing the forums.  There are a myriad of issues: getting field widths and field types correct, etc.

 

So, as a precaution and a best practice, I always export to tab delimited, text format as well.

 

Have a great day!

John Raabe, CISA
Lead IT Auditor
Allina Audit Services
P: 612-262-4848
F: 612-262-4840
email: john....@allina.com

---

This message contains information that is confidential and may be privileged. Unless you are the addressee (or authorized to receive for the addressee), you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received the message in error, please advise the sender by reply e-mail and delete the message.

[Lisa J Nkhata]

I prefer to save the Excel file as a DBF 4 format which also works around the problem without having to request or download a different file type.  Good luck.



Lisa Nkhata
Senior Information Systems Auditor
Hutchinson Technology
40 West Highland Park, MS 73
Hutchinson, MN 55350
320.587.3797, ext. 4438

"Raabe, John J" <John....@allina.com> Sent by: minn...@googlegroups.com 02/23/2009 11:00 AM Please respond to minn...@googlegroups.com

To <minn...@googlegroups.com> cc

[Trinh Tran]

I got it to finally work after few trials with text delimited.  Thanks to all for your input! 

 

---

<br

[Ryberg, Nicholas]

That works great too, but I think they disabled DBF 4 export in Excel 2007.  This was a method we used to use a lot in our shop until the upgrade.

 

- Nick

<br