Page 1 of 1
Exporting to Excel
Posted: 21 Jan 2009, 08:40
by mikedry
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?
Posted: 23 Jan 2009, 12:31
by brucedenney
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?
Posted: 26 Jan 2009, 08:12
by mikedry
Hi
Opened with notepad and the info is there
Posted: 28 Jan 2009, 15:07
by brucedenney
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.
Posted: 28 Jan 2009, 15:24
by mikedry
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?
Posted: 28 Jan 2009, 15:30
by brucedenney
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.
Posted: 28 Jan 2009, 15:37
by mikedry
I produce report, go to Export and then click on format of .CSV, put in filename and save (usually to desktop)
Posted: 29 Jan 2009, 19:34
by brucedenney
Are you giving the file name an extension? Is the file created associated with excel?
Posted: 30 Jan 2009, 08:21
by mikedry
I have tried it with and without a file extension.
Posted: 30 Jan 2009, 10:10
by brucedenney
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?