I notice there are many examples around of using vb6 to fill a MsAccess table with data from a FILE containing CSV data.
My problem is I have the CSV data in a single string, having received it from an internet site using WinHTTP.
I want to use this text to create a table so I can use SQL to do various queries.
I could do this 2 cludgy ways by labouriously seperating each field and writing it to a table using recordsets OR save text to a file and immediately use the above method to create the table.
Is there a way of using a similar method as the CSV file to table but in effect using CSV string to table instead?
I haven't found one yet but maybe I am looking in the wrong place?
My problem is I have the CSV data in a single string, having received it from an internet site using WinHTTP.
I want to use this text to create a table so I can use SQL to do various queries.
I could do this 2 cludgy ways by labouriously seperating each field and writing it to a table using recordsets OR save text to a file and immediately use the above method to create the table.
Is there a way of using a similar method as the CSV file to table but in effect using CSV string to table instead?
I haven't found one yet but maybe I am looking in the wrong place?
