Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

Exporting to Excel

Sage 50 general help forum - Free help and support for all general issues
Post Reply
mikedry
User
User
Posts: 5
Joined: 21 Jan 2009, 08:38

Exporting to Excel

Post by mikedry » 21 Jan 2009, 08:40

Hi

Am trying to export to Excel in CSV format but when I open the file nothing is there. The file appears on my desktop but is empty.

Other formats such as PDF work fine.
Any ideas?
Top
User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Post by brucedenney » 23 Jan 2009, 12:31

Try opening the file with notepad and see if there is anything there.

Are you sure you selected csv from the drop down box of file types?
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Top
mikedry
User
User
Posts: 5
Joined: 21 Jan 2009, 08:38

Post by mikedry » 26 Jan 2009, 08:12

Hi

Opened with notepad and the info is there
Top
User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Post by brucedenney » 28 Jan 2009, 15:07

That suggests that your original statement is incorrect.

You need to save the file with the extension .csv so that some application on your PC (probably excel) can know what type of data it is and open it appropriately.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Top
mikedry
User
User
Posts: 5
Joined: 21 Jan 2009, 08:38

Post by mikedry » 28 Jan 2009, 15:24

I have saved it as CSV and it still wont open in Excel. It also now isn't opening in Notepad
Could it be a seeting in Excel?
Top
User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Post by brucedenney » 28 Jan 2009, 15:30

Did you use the csv extension when you saved it this is in addition to selecting the csv format?

Can you give details of how you produce the file.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Top
mikedry
User
User
Posts: 5
Joined: 21 Jan 2009, 08:38

Post by mikedry » 28 Jan 2009, 15:37

I produce report, go to Export and then click on format of .CSV, put in filename and save (usually to desktop)
Top
User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Post by brucedenney » 29 Jan 2009, 19:34

Are you giving the file name an extension? Is the file created associated with excel?
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Top
mikedry
User
User
Posts: 5
Joined: 21 Jan 2009, 08:38

Post by mikedry » 30 Jan 2009, 08:21

I have tried it with and without a file extension.
Top
User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Post by brucedenney » 30 Jan 2009, 10:10

What version of Sage 50 are you running?

Is this a network or single user installation?

Does this happen with all reports or just some?
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Top
Post Reply

Return to “Sage 50 UK version General Help”

Who is online

Users browsing this forum: No registered users and 24 guests