Current Position:Home > Loading 361000 records at a time from csv file

Loading 361000 records at a time from csv file

Update:10-11Source: network consolidation
Advertisement
Hi,
One of my collegue loaded 361000 records from one file file , how is this possible as excel accepts 65536 records in one file
and even in the infopackage the following are selected what does this mean
Data Separator   ;
Escape Sign      "
Separator for Thousands   .
Character Used for Decimal Point   ,
Pls let me know

The Best Answer

Advertisement
hi Maya,
it just possible, other than ms-excel, we have editor like Textpad that support more 65k rows (and windows Notepad), the file may be generated by program or edited outside in excel, or newer version of excel is used, ms-excel 2007 support more 1 million rows.
e.g we have csv file
customer;product;quantity;revenue
a;x;"1.250,25";200
b;y;"5.5";300
data separator ;
- char/delimeter used to separate field, e.g
escape sign, e.g
- "1.250,25";200 then quantity = 1.250,25
separator for thousands = .
- 1.250,25 means one thousand two hundred ...
char used for decimal point
- - 1.250<b>,</b>25
check
http://help.sap.com/saphelp_nw70/helpdata/en/80/1a6581e07211d2acb80000e829fbfe/frameset.htm
http://help.sap.com/saphelp_nw70/helpdata/en/c2/678e3bee3c9979e10000000a11402f/frameset.htm
hope this helps.
  • Loading 361000 records at a time from csv file Update:10-11

    Hi, One of my collegue loaded 361000 records from one file file , how is this possible as excel accepts 65536 records in one file and even in the infopackage the following are selected what does this mean Data Separator   ; Escape Sign      " Separat

  • How to update Records of SAP table from .CSV file Update:10-11

    Hi, I have written a code which takes a data from (,) delimited CSV file and adds it into the Internal table. Now I want to update the all fields in SAP table with the Internal table. I want to use Update statement. Update <table Name> SET <field

  • SQL*Loader - How to load only a few columns from a .csv file to ora table Update:10-11

    Hi there, Could anyone please let me know how to load few columns from a .csv file into a oracle table using SQL*Loader. I know how to create a .dat and .ctl file and run the sql loader. Suppose I have a .csv file with col1, col2, col3, col4 and I on

  • First Row Record is not inserted from CSV file while bulk insert in sql server Update:10-11

    Hi Everyone, I have a csv file that needs to be inserted in sql server. The csv file will be format will be like below. 1,Mr,"x,y",4 2,Mr,"a,b",5 3,Ms,"v,b",6 While Bulk insert it coniders the 2nd column as two values (comma

  • Deleted contacts from iphone 4s, loaded new contacts from to phone from .csv file.  then I enabled icloud and it put all my old contacts back. Update:10-11

    My wife and I both have Iphones.  For the past 18 months her phone and mine had the same appleID (mine).  When I set up iCLoud backups and synch a month ago, my wifes phone ended up with all my contacts (1400+) and her's (<100) mixed together.  Didn'

  • Error while Loading data through .csv file Update:10-11

    Hi, I am getting below date error when loading data through into Olap tables through .csv file. Data stored in .csv is 20071113121100. TRANSF_1_1_1> CMN_1761 Timestamp Event: [Mon Mar 29 15:06:17 2010] TRANSF_1_1_1> TE_7007 Transformation Evaluation

  • How to create  a datasource for 0COSTCENTER to load data in csv file  in BI Update:10-11

    how to create  a datasource for 0COSTCENTER to load data in csv file  in BI 7.0 system can you emil me the picture of the step about how to  loaded individual values of the hierarchy using CSV file thank you very much my emil is <Removed> allenStep

  • Need to load 2.4GB CSV file Update:11-30

    I would like to load a portion of a 2.4gb csv file to a 10g table. The file is too large to open in notepad or excel. How can I load a portion of this file to a table? Can I load the data into a generic table(do not define columns). Let the file dict

  • Load IDM users using CSV file Update:11-30

    I am trying to load some users into IDM using a CSV file: command, accountId,waveset.firstname,waveset.lastname,waveset.email Create,testid,james,smith,[email protected] Create,testid2,sally,gray,[email protected] After loading i can see that the acc

  • Error importing CSV files with 'hidden' characters using External Table Update:11-30

    Hi Folks Bit of a strange one here. We're well used to using the External Table method of loading data from CSV files into the database but a recent event has presented us with a problem. We have received some CSV files that 'look' like regular CSV f