COPY table_name FROM 'C:UsersPublicDocumentsert.txt' DELIMITER ',' CSV -- make sure to put the file in public folder in windows -- Or temp folder in linux/mac -- because it might ask for some permissions...