Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Exporting to excel from SAP
Hello Microsoft Guru's
I need a little help from you guys. What happens is when we take a list out of SAP: List - Save to PC file - Save list in file... Spreadsheet. then save the file as eg. filename.xls When i open the file it looks like a excel file, but when i save the changes in excel i get a window up that says: filename.xls may contain features that are not compatible with Text (tab delimited). Do you want to keep the workbook in this format? °To keep this format, which leaves out any incompatible feature, click Yes. °To preserve the features, click No. Then save a copy in the latest excel format. °To see what might be lost, click Help. Then again, If i say save as.. and select the original file then it looks like it´s a .txt file not .xls and i have to save it especially as .xls I don´t want to have to tell people that they have to import the file into Excel, just opening the file should be enough. Does anyone know what i´m talking about??? I have talked to the people at SAP and they say it´s a Microsoft problem. Thanks SAPGirl |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Exporting to excel from SAP
Hi
I know nothing about SAP. However, it sounds to me as though the output file is a .csv file, which Excel will quite happily open. When you save it, then you can select from the File type option to save it as a .xls file and ignore the warnings. If you have added any formulae, changed layouts, done any formatting etc., then all of these will be saved as the .xls file which will not be readable in the same way as the original .csv In my opinion, when saving the file from SAP, you should be calling it filename.csv, not filename.xls After your save in Excel, you would then have the new filename.xls file and your original file of filename.csv would still be there exactly as exported from SAP. -- Regards Roger Govier "SAPGirl" wrote in message ... Hello Microsoft Guru's I need a little help from you guys. What happens is when we take a list out of SAP: List - Save to PC file - Save list in file... Spreadsheet. then save the file as eg. filename.xls When i open the file it looks like a excel file, but when i save the changes in excel i get a window up that says: filename.xls may contain features that are not compatible with Text (tab delimited). Do you want to keep the workbook in this format? °To keep this format, which leaves out any incompatible feature, click Yes. °To preserve the features, click No. Then save a copy in the latest excel format. °To see what might be lost, click Help. Then again, If i say save as.. and select the original file then it looks like it´s a .txt file not .xls and i have to save it especially as .xls I don´t want to have to tell people that they have to import the file into Excel, just opening the file should be enough. Does anyone know what i´m talking about??? I have talked to the people at SAP and they say it´s a Microsoft problem. Thanks SAPGirl |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Exporting to excel from SAP
Some notes from my SAP experience:
1) SAP people tend to hate MS Excel and so claim that problems exporting SAP data to Excel are the fault of MSFT. That won't change. 2) SAP appears to save exported data as a .xls file, but with .csv formatting. This makes no sense and I have never received a sensible explanation for it, but this seems to be its mode of operation. Perhaps someone can give more detail about this. 3) I don't use SAP any more (thank god), however I recall that various SAP User groups had extensive information on this issue. Further, are there people internal at your company (not SAP people) who know how to resolve this? They may be a good resource as well. Good luck. Dave -- Brevity is the soul of wit. "Roger Govier" wrote: Hi I know nothing about SAP. However, it sounds to me as though the output file is a .csv file, which Excel will quite happily open. When you save it, then you can select from the File type option to save it as a .xls file and ignore the warnings. If you have added any formulae, changed layouts, done any formatting etc., then all of these will be saved as the .xls file which will not be readable in the same way as the original .csv In my opinion, when saving the file from SAP, you should be calling it filename.csv, not filename.xls After your save in Excel, you would then have the new filename.xls file and your original file of filename.csv would still be there exactly as exported from SAP. -- Regards Roger Govier "SAPGirl" wrote in message ... Hello Microsoft Guru's I need a little help from you guys. What happens is when we take a list out of SAP: List - Save to PC file - Save list in file... Spreadsheet. then save the file as eg. filename.xls When i open the file it looks like a excel file, but when i save the changes in excel i get a window up that says: filename.xls may contain features that are not compatible with Text (tab delimited). Do you want to keep the workbook in this format? °To keep this format, which leaves out any incompatible feature, click Yes. °To preserve the features, click No. Then save a copy in the latest excel format. °To see what might be lost, click Help. Then again, If i say save as.. and select the original file then it looks like it´s a .txt file not .xls and i have to save it especially as .xls I don´t want to have to tell people that they have to import the file into Excel, just opening the file should be enough. Does anyone know what i´m talking about??? I have talked to the people at SAP and they say it´s a Microsoft problem. Thanks SAPGirl |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Exporting to excel from SAP
Hi,
As i understand u have problem after opening the export file from SAP. u are doing correct but when u save it after opening first time just change type (microsoft excel workbook) then u will not get any problem. regards zafar "SAPGirl" wrote: Hello Microsoft Guru's I need a little help from you guys. What happens is when we take a list out of SAP: List - Save to PC file - Save list in file... Spreadsheet. then save the file as eg. filename.xls When i open the file it looks like a excel file, but when i save the changes in excel i get a window up that says: filename.xls may contain features that are not compatible with Text (tab delimited). Do you want to keep the workbook in this format? °To keep this format, which leaves out any incompatible feature, click Yes. °To preserve the features, click No. Then save a copy in the latest excel format. °To see what might be lost, click Help. Then again, If i say save as.. and select the original file then it looks like it´s a .txt file not .xls and i have to save it especially as .xls I don´t want to have to tell people that they have to import the file into Excel, just opening the file should be enough. Does anyone know what i´m talking about??? I have talked to the people at SAP and they say it´s a Microsoft problem. Thanks SAPGirl |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Exporting data from access to excel | Excel Worksheet Functions | |||
Exporting to Excel from a program like Oracle | Excel Discussion (Misc queries) | |||
Exporting excel to text file | Excel Discussion (Misc queries) | |||
Exporting numbers into Excel | Excel Discussion (Misc queries) |