VB Forum / General 2 / October 2003

As a learner I am grateful to all who has helped me in my learning
process. Here is another question (Simple) that I would like to post.
I will appreciate your reply very much.

I want to acess data in csv format with the header containing the
field names. I would like to use these field names while creating
Table using SQL statements. How can I achieve this?

For example:
After reading the csv file we get following into the VB6

x=date
y=incoming students
z=outgoing students
so,
Fieldname(0).name="date"
Fieldname(1).name="Incoming students"
Fieldname(2).name="outgoing students"

Now I would like create Table using SQL statement. e.g.

cmd.CommandText="CREATE TABLE (x DATE/TIME PRIMARY KEY,Y char(10),Z
char(10))"
cmd.Execute, ,adCmdText

I find x, y,z cannot take the values as assigned. Is there someway
out?

thanking you, always