Importing from excel

[Anonymous]

I am trying to import a worksheet from excel that has 301,463 rows.  When I add script RecNo() as RecordID. 

Upon reload I only see 153,389 rows.  I fully anticipate the reduction rows as there are several with blanks, however it isn't roughly half.  I did use the transformation step

(

txt, codepage is 1252, embedded labels, delimiter is '\t', msq, header is 32 lines, filters(
Remove(Row, Pos(Top, 2)),
Remove(Row, Pos(Top

, 2)),
));

[Gysbert_Wassenaar]

txt, codepage is 1252,, embedded labels, delimiter is '\t',

That's for loading a text file with the fields separated by tabs, not for an excel file. Check that you're using the correct codepage and that the file doesn't contain special characters like unicode characters or unprintable characters.

[Anonymous]

Thank you very much. As I reviewed that very thing that is what I found. Made the correction and is working as intended.