Be patient, if one of the columns is a date field you may want to import it as a text file instead. That works for me with large files like that.
Lance Sent from my Verizon, Samsung Galaxy smartphone -------- Original message -------- From: "[email protected]" <[email protected]> Date: 11/8/20 8:20 PM (GMT-05:00) To: RBASE-L <[email protected]> Subject: [RBASE-L] - Importing A Large XLSX file using Gateway CAUTION: This Email is sent from outside our organization. Please DO NOT Click on any links or open any attachments unless you recognize the sender. Please forward any Suspicious Email "as an attachment" to [email protected]<mailto:[email protected]> I am trying to import a file with four columns and 583418 rows using Gateway (via a command file - R:Base X5 Enterprise). While this works with a version of the spreadsheet with only 200 rows, when I try to import the entire file I do not see the progress indication or anything that indicates that the file is being processed or that an error has occurred. I was just wondering if I am exceeding a limit here or do I just need to be patient ? Any advice would be much appreciated. Thank you. Regards John Docherty -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php<https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.rbase.com%2Fsupport%2Fusersgroup_guidelines.php&data=04%7C01%7Clhannaw%40bronxleb.org%7C71e5f3e17107453bd98908d8844da0ab%7C4298a6c031114e0cb60c030ea7ab66ee%7C0%7C0%7C637404816247558975%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=l23nRi%2BQxeFJap79tBwzdjJ9htZKEtv8OSZt%2BXO1LeM%3D&reserved=0> --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/90ed6761-b2cd-49eb-9c4f-d31b15de55ffn%40googlegroups.com<https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Frbase-l%2F90ed6761-b2cd-49eb-9c4f-d31b15de55ffn%2540googlegroups.com%3Futm_medium%3Demail%26utm_source%3Dfooter&data=04%7C01%7Clhannaw%40bronxleb.org%7C71e5f3e17107453bd98908d8844da0ab%7C4298a6c031114e0cb60c030ea7ab66ee%7C0%7C0%7C637404816247568969%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=%2FA%2BXQUiXH36OfFwWYUf9MdHFEFZ2kgJ1GdJI%2Fqq%2FW8g%3D&reserved=0>. CONFIDENTIALITY NOTICE: This communication and any attachments may contain confidential and/or privileged information for the use of the designated recipients named above. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify the sender immediately by email or telephone and destroy all copies of this communication and any attachments. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/MN2PR11MB3901D2182EC5C03F72C7AE02DFEA0%40MN2PR11MB3901.namprd11.prod.outlook.com.
