Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel 2013 cannot open simple text file with .acc extension

02 Feb 2015   #1
gacuxz

Windows 8 Professional x64
 
 
Excel 2013 cannot open simple text file with .acc extension

Inside .acc file is a simple text, but the mighty Excel tries to open it like some kind of database. It is asking for accounts, sources, passwords etc. and finally it cannot open it at all. It can open this file if I change extension to something else like .txt or .xls. How can I turn off this useless function of Excel 2013? The Excel of 2003 just opens it without any question.


My System SpecsSystem Spec
.
02 Feb 2015   #2
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

Hi gacuxz, welcome to Windows Seven Forums.

MS changed Office file extensions from version 2007. This website might it explain it for you.

Microsoft Office file extensions list

When you have opened the file in question, by the method you mention, have you tried saving it, using the Save As option, with a file extension listed in the Save As options list.
My System SpecsSystem Spec
02 Feb 2015   #3
gacuxz

Windows 8 Professional x64
 
 

Hey Ranger4, thanks for reply. Unfortunately, site you gave me says nothing about .acc extension. After Save As procedure the new file can be opened without problems. Unfortunately our workers get dozens of .acc files a day so procedure Rename --> Save As --> Reopen --> Delete original file for each of them is just ridiculous. I'm looking forward to somehow disable this dumb automatic detection function by file extension or file header reading.
My System SpecsSystem Spec
.

02 Feb 2015   #4
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

Thanks for getting back. I suggested that website to explain when MS changed the file extensions. I did notice that it did not mention .acc files.
I cannot offer you any more help with this problem. Perhaps someone else my come in that is more knowledgeable & suggest a solution.
My System SpecsSystem Spec
21 Mar 2015   #5
gacuxz

Windows 8 Professional x64
 
 

Well, thanks for trying Ranger4. Awesome. Damn Microsoft makes one more stupid function and no one even knows how to turn it off. I bet no one even knows what kind of problem I have. Feels like real MS teamwork. Wonder when the salvation will come and Microsoft will go for something like excrements alteration or something. Maybe there they would be better at something.
My System SpecsSystem Spec
21 Mar 2015   #6
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

Hi gacuxz, what types of files use the .acc extension. Have a read through the attached website link about .acc files. It appears that you may need some software for these files to open properly. There is a link for some software for that with in the text, but I have no idea of it's validity, you may need to do more research on it.

.acc File Extension - What is a .acc File Type? | ReviverSoft
My System SpecsSystem Spec
21 Mar 2015   #7
strollin

W10 Pro desktop, W10 laptop, W10 laptop, W10 Pro tablet (all 64-bit)
 
 

Quote   Quote: Originally Posted by gacuxz View Post
Well, thanks for trying Ranger4. Awesome. Damn Microsoft makes one more stupid function and no one even knows how to turn it off. I bet no one even knows what kind of problem I have. Feels like real MS teamwork. Wonder when the salvation will come and Microsoft will go for something like excrements alteration or something. Maybe there they would be better at something.
Since you have no idea why the change was made, how can you make remarks about MS? My guess is that the change was made to not blindly open any old file you ask it to in order to protect you from accidentally running a rogue macro or some other security hole.

Do you think they made the change simply to make life more difficult for you? Why not contact the source of these .acc files and ask that they be saved in a different format with a different extension?
My System SpecsSystem Spec
24 Aug 2015   #8
gacuxz

Windows 8 Professional x64
 
 

Quote   Quote: Originally Posted by strollin View Post
Since you have no idea why the change was made, how can you make remarks about MS? My guess is that the change was made to not blindly open any old file you ask it to in order to protect you from accidentally running a rogue macro or some other security hole.

Do you think they made the change simply to make life more difficult for you? Why not contact the source of these .acc fies and ask that they be saved in a different format with a different extension?
MS often changes something to push people to do something that MS need. Not the user. We are getting .acc files from bank as reviews. We have many users using them. Bank has many customers, who uses them. And now because Microsoft suddenly decided it may be a security hole we have to reinvent all system once again?
Bank recommends us to use Office 2003. MS is recommending to use Office 2013. This pisses of users and MS started it! Why just not to make an option in Office 2013 to turn this off? But no! Once again - MS knows better how we need to live.
As to strollin, I think MS's politics is as like as to prevent killing of pedestrians is to deny driving cars cause they built too many pedestrian crossings.
My System SpecsSystem Spec
24 Aug 2015   #9
UsernameIssues

W7 Pro SP1 64bit
 
 

Do you have a sample ACC file that you could upload? I spent a while looking for a sample and could not find one.

What Is an ACC File Extension? | eHow

Using an XP virtual machine, I downloaded/installed software from CNET* made by FKJ Software that creates financial data/charts and saves them in the ACC file format. Office 2003's Excel would not open the file. Perhaps your bank is not using software by FKJ Software.

*Don't download software from CNET. It is often times full of other unwanted apps.


As for why MS stopped opening ACC files, perhaps MS is no longer willing to pay the licensee fee to do so.
My System SpecsSystem Spec
26 Aug 2015   #10
bawldiggle

XP/7x32 & x64/8x64/8.1x64
 
 
More than one way to skin a cat ...

As a suggestion ...

An Excel template with a sheet/ribbon button to identify the ACC file and copy (using Excel macros) the ACC contents to populate the active Worksheet. By using Excel code (my expertise is with VBA) any quirks on the ACC data could be "corrected" before populating the Excel worksheet. (eg, date formats, each record's fields delimiter.
I am assuming the ACC file is a simple fields(columns) X records(rows) "text" file structure

Using code also opens up a world of flexibility eg, to import or hide fields with just the click of a custom control
- and by using late bound classes it would (I think) might be usable in Excel 2003 and Excel 2013

Don't underestimate the power of Excel, The majority of users are only accessing about 20% of its potential.
-----
If the ACC file is copy pasted onto an Excel spreadsheet do you get the results you seek ?
- I am just trying to understand the structure of the database ... (comma delimited, tab delimited ... etc)
- personally I find the Excel importing feature too complex, so I choose to write templates to import regularly used data base text.
My System SpecsSystem Spec
Reply

 Excel 2013 cannot open simple text file with .acc extension




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Excel 2013 crashes after opening and using any xls/xlsx file
Hi Members, when I open any XLS or XLSX file after few seconds or after doing any activity in any xls/xlsx file, Excel 2013 crashes (Office 2013 is updated to latest). There are no third party plugins enabled in Office 2013. http://i.imgur.com/LRSV58D.png http://i.imgur.com/nO793Dg.png ...
Microsoft Office
Excel 2013 Won't Automatically Open Files
I am running into a bizarre problem with Excel 2013 and I can't seem to figure out the cause - searching around I couldn't find a solution, either. I have both Office 2010 64-bit and Office 365 (2013) 64-bit installed on my Windows 7 system. The only reason I still need 2010 is that 2013's...
Software
Stop Excel 2010 from appending .txt to file with existing extension
I think this problem may have to do with Windows 7 vs Windows XP. With Excel 2010 running under XP this does not happen. Under Win 7 running Excel 2010, when saving a spreadsheet as a tab delimited text file (.txt). Excel 2010 appends the .txt file extension to a file that already has an...
Microsoft Office
Open Excel file to directly open from IE9
Hello guys, I wanted to open an excel file directly from IE9, but when I double click the excel file in the browser, it opens right in IE instead of Excel program. How do I make the file use Excel program to open rather than open in IE itself? I am using Windows 7 and Office 2010. I tried the...
Microsoft Office
Please Help - Data in Text File to be arranged in Excel in a specific
Hello Everyone, Its my first post here :-) I have a text file with values printed like these; BSSID: 001E4ABXXXX Last seen: 14/12/2011 - 16:06:12 Vendor: Cisco Systems Signal: -91 dBm SSID: NXXXX Enc: OPEN
Microsoft Office
How to open .dmg file extension????
can anyone tell me how do i can open a .dmg file in windows and can be able to burn that file in some cd/dvd ??????
General Discussion


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 05:48.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App