csv, ado, datagrid problem

[bbolte]

i'm trying to get a csv file into a datagrid. here's the code:

code:Set connCSV = New ADODB.Connection
With connCSV
.CursorLocation = adUseClient
.ConnectionString = "Driver={Microsoft Text Driver (*.txt; *.csv)};Initial Catalog=C:\ShipFDX\ARCHIVE\"
.Open
End With
sSQL = "SELECT * FROM [Apr1904-LTL.csv]"
'// bind to dg
Set dgShip.DataSource = connCSV.Execute(sSQL)
Set dgShip.DataSource = Nothing

no errors but nothing is in the datagrid either...

 

[Swi]

By setting the datagrid to Nothing you are clearing it. Comment out that line and it should work. Set it to Nothing before you unload the form.

Swi

 

[bbolte]

i had done that already and it didn't make a difference. i've got it working with a little different set up. thanks...