Loading more than 65536 records in to Bw using Excel

[Former Member]

Hi,

I am loading data in to BW using flatfiles , as I have huge amount of data i.e more than 65536 records as excel supports to load only 65536 records , is there any way to upload all my records in to BW

Thanks

Priya

[Former Member]

if your files are on application server

select load files from application server in external tab in infopackage.

hope this helps

[Former Member]

Hi Priya,

You have 2 options:

1. Split the flat file into smaller files.

2. You can create the ".csv"or ".txt" using wordpad or notepad where you canhave more than 65536 records.

Bye

Dinesh

[Former Member]

Hi,

Thanks for ur response

If I save it in txt format what is the seperator needs to be used,generally for csv we use , and ;can i load data in to bw from MS-Access,if so is there any restriction for no. of records

Priya

[edwin_harpino]

hi Priya,

use excel 2007

use other text editor like TextPad ...

for txt format load, check Eugene's weblog

/people/sap.user72/blog/2006/05/27/long-texts-in-sap-bw-modeling

maybe use ms-sql if you have, and load with db connect

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/2f0fea94-0501-0010-829c-d6b5c2ae...

hope this helps.

[Former Member]

Hi Edwin,

Thanks for ur response.

If I use Excel 2007 what would be the limit for no.of records,wont there be any limit Please let me know

priya

[edwin_harpino]

hi Priya,

the limit is 1,048,576 rows.

hope this helps.

[Former Member]

Hi,

do not use excel store your data with notepad or another texteditor

/manfred