import data bank branches

[Former Member]

hello,

I want to import data from 50.000 bank branches in a user table directly from sql, what kind of query can i use? There is another method? i use sql server express edition....thanks

[former_member186095 · Accepted solution]

Do you mean user table here is the table created directly in in the SAP B1 database server ? is the prefix name of table @ ? Or the user table is a table created from manage user field --> user table ? if yes,

DTW can't upload the data to that table. You must use DTS of SQL server management studio. You prepare the excel template and use the DTS to upload it to the table.

Rgds,

[former_member583013]

Is the User table created from SAP. If so, I would suggest you to use DTW.

Prepare an Excel similar to the DTW template with 2 rows of the same data.

Name the columns the same as in User Table.

If you user table is defined as no object then you would need to include code and name column in your DTW. Remember Code and Name are primary key columns and have to be Unique.

Example of Excel template

Code........Name........U_Field1............U_Field2........

Code........Name........U_Field1............U_Field2........

Suda