importing CSV file into ms access table using vb

[moeller]

My effort is to import CSV file that has date and time
field into an access table programmatically. Can any one
suggest the best way of doing this. I've tried to open the
csv file as input and read each line and then use sql
query INSERT INTO.

I believe there is some thing like

ocmnd.Execute "Select * into [tblname] From
[Text;Database= C:\].[cvsfilename]

Thank you.

--moeller

[Gary Walter]

"moeller" <muluget...@corporate.ge.com> wrote

Hi Moeller,

This may help,

HOWTO: Open Delimited Text Files Using the Jet Provider's Text IIsam

http://support.microsoft.com/default.aspx?scid=kb;en-us;262537

In my experience, I don't "trust" text files, i.e., it has always
worked best for me to import into a temp table, then insert
data from temp table into "production" table.

You might also check out
DoCmd.TransferText

Please respond back if I have misunderstood.

Good luck,

Gary Walter