Working With ASCII Files

[FlipKid]

Hi, I am a relative newbie to Visual Basic databases, and I have a couple of questions... first off, I have an ascii text file in the following format:

Col1,Col2,Col3,Col4
1,"Hello",0000001,1.001
C,"blah",0000002,1.002

In my datagrid, after executing: "SELECT * FROM text.txt" it displays the following:

Col1 Col2 Col3 Col4
1 Hello 1 1
blah 2 1

How can I make it see Column 1 as a single char, Col2 as a string preserving the quotes, Col3 as a string w/o quotes (so it contains the whole number), and Col4 as a single?

Thanks in advance for any help.

[WattsTech]

com databasing científico do conhecimento da perícia.