cancel
Showing results for 
Search instead for 
Did you mean: 

Campaign Generation Wizard - Import from Excel failure

0 Kudos
52

Hi all,

I'm trying to import business partner "target group" template into SAPB1 from Excel,

I tried a simple test of this and I can't get it to work - I've searched these forums and I can't find a similar case.

Here's the test Excel worksheet that I tried to import:


Here's the cell alignment in SAPB1:

When I press OK I'm asked to open the file in question.

The default filename is "*.txt" and the only file extension offered is "Text files (*.txt)".

I can manually change the file extension to XL by typing "*.xls" in the "File name" box - this shows my excel worksheet, but when I try to load it, it fails.

Similarly, I can save a copy of the excel worksheet as a txt file.

Both fail with the following error:    

As you can see, Excel is not open here - as other reports of similar failures seem to point out as a common cause.

Any help would be greatly appreciated.

Thanks,

Cal.

Accepted Solutions (0)

Answers (3)

Answers (3)

0 Kudos

No Addons running, just won't work...

Any other ideas?

former_member196081
Active Contributor
0 Kudos

Replace your text file column as below

BP code     Contact Person     Title     Position

and follow the same pattern in "import from excel"

0 Kudos

Hi guys,

thanks for the response but it still won't work...

here's some more screen dumps of what is going on:

Excel sheet:

SBO:

then..

and finally:

former_member196081
Active Contributor
0 Kudos

stop if there is any addon running. and comment all transaction notification if any exist.

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please refer SAP help file for importing BP through Excel:

http://help.sap.com/saphelp_sbo900/helpdata/en/45/06da78d8696c30e10000000a114a6b/content.htm

Thanks & Regards,

Nagarajan