Rex:
Hope this code that cathy send to me work for you or give you some ideas how to work with your problem.
Dim dr As DataRow
Dim fi As FileInfo
Dim dir As New DirectoryInfo("C:\")
Dim dt As New DataTable()
dt.Columns.Add("FileName", GetType(System.String))
dt.Columns.Add("Size", GetType(System.Int32))
For Each fi In dir.GetFiles()
dr = dt.NewRow()
dr(0) = fi.Name
dr(1) = fi.Length
dt.Rows.Add(dr)
Next
I change that a littler because i that time i did not know the value for each individual column so i place a Space(1) value in the column that giveme the null error. BTW the error was by definition in the sql server that did not accept null values.