cancel
Showing results for 
Search instead for 
Did you mean: 

Import Data From Excel

Former Member
0 Kudos

Hi experts

I am facing a problem while importing data from excel. When i am saving the excell file as text (tab delimeted) the system is giving an error message as " the file that you want to convert is not compatible with text tab delimeted format" do you want to continue.

when i am performing improt it gives error messages.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

Are all your data in the file meet the requirement by B1?

· The files must not contain a title row or any blank rows.

· The numbers of the business partners and items must not contain any of the following characters: ! < > * ? % { } =

· Close the Microsoft Excel file before the import.

· Save the Microsoft Excel file as .txt file (text file with u201CText Onlyu201D).

· The data to be imported has to be saved in columns A to BT in the Microsoft Excel table. The number of characters in the cells of the Microsoft Excel table must not be greater than the length of the corresponding field in SAP Business One. Some columns can have empty fields.

Thanks,

Gordon

Former Member
0 Kudos

BP

Former Member
0 Kudos

I think you have version problem with Microsoft office. Which version you are using?

Why dont you try it with DTW?

Rahul

Former Member
0 Kudos

Hi Rashid....

For what you are importing data. I mean to say Item or BP?

Regards,

Rahul