Hi there
I have just set up my new PC, installed Sage 50 (v16, 2010), and all works fine. I tried to import my journals from an XLSX file, as I have been doing for years on the old PC, but the Excel option is greyed out, so will only allow import from csv.
new PC details:
Windows 7 Professional
Excel 2010
Sage 50 Accounts Plus 2010 v16.0.17.0158
I have a SSD to store my programs and a traditional spinning HDD to store my data. All the sage data ie Company.000, Company.001 etc folders on are on the HDD. Sage itself is installed on the SSD. I told Sage (by editing the company (no extension) file) to find the data on the HDD, and it works fine. The one thing it can't do is import from an xlsx file.
Does anybody know why this might be happening, and what I can do to make it work properly?
Thanks in advance.
Martin
Replies (5)
Please login or register to join the discussion.
File - Save As*
Hi Martin,
If sage requires a csv file to be imported (like with other programs that require a simpler file) simply open your excel document and save the file as a csv file.
This should change the file to the format required by sage.
Regards
P J Owen
I'm sorry for stating the obvious I wasn't sure of your computing knowledge. I think maybe a call to sage support, more of an IT issue than an accounting issue?
Regards
It sounds as if
Sage is not "seeing" the Excel installation.
You could try excel.exe /unregserver and excel.exe /regserver from the command prompt or, in similar circumstnaces, what I have found more effective* is to "repair" the Office 2010 installation.
* though not with Sage which I haven't had problems with.