Skip to Content
author's profile photo Former Member
Former Member

Import Excel sheet into SBO

Hi Everyone,

I wanted to know if it is possible to import a Excel file into a User Defined Table within Business One

Thanks,

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 16, 2008 at 02:45 PM

    Depending on where the value in the Excel is to be imported you will need to add a column with the User field name to the appropriate DTW template and then import the value.

    Could I ask what you are trying to import. Which module have you added this User field in Business one.

    Suda

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      If they are SAP fields then they should be available on the template, for user fields you can add them to the template at the End similar to the SAP field.

      Please use the same name as the User field U_abcd and add them in both rows

      U_abcd

      U_abcd

      Suda

  • author's profile photo Former Member
    Former Member
    Posted on Jun 16, 2008 at 02:43 PM

    I think that there are 3 ways:

    1. with di api read the xls file and insert records into user defined table

    2. because the udt has no relationship with system tables I would prefer to make direct inserts into tables with standard import function of sql server

    3. create excel sheet and between the cells add tab key (char 9) and open user table in sap (settings - user tables) and through copy paste add the datas there

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.