Hi, I am trying to pull a csv file into a worksheet within a workbook and despite long searching have not yet found a solution.
A single line would typically be in the following format:
407,"2018-07-24 12:21:08",processing,130.00,paypal,fist name,surname,name@email.co.uk,07123123456,"Hi, this is a comment, with multiple commas",,Name1,Name2,6:15,Premier,,
As you can see, some fields may be blank, some will be in quotation marks and contain several commas that should not be delimiters.
When I double click the file to open it in Excel it comes through fine but of course I lose leading zero's from telephone numbers etc. Every VBA import routine I have tried splits the file at the commas within the quotes. I have tried renaming the extension to .txt and using the text import wizard but this does the same.
I would be grateful if anyone has a solution to this.
Many thanks
A single line would typically be in the following format:
407,"2018-07-24 12:21:08",processing,130.00,paypal,fist name,surname,name@email.co.uk,07123123456,"Hi, this is a comment, with multiple commas",,Name1,Name2,6:15,Premier,,
As you can see, some fields may be blank, some will be in quotation marks and contain several commas that should not be delimiters.
When I double click the file to open it in Excel it comes through fine but of course I lose leading zero's from telephone numbers etc. Every VBA import routine I have tried splits the file at the commas within the quotes. I have tried renaming the extension to .txt and using the text import wizard but this does the same.
I would be grateful if anyone has a solution to this.
Many thanks