mibushk
04-27-2012, 12:00 AM
I am trying to make an export from a tool and then import in a second one
this is done via vba
I export info in a .csv file
and then read the .csv file with
objConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & strPathToTextfile & ";" & _
"Extended Properties=""text;HDR=YES;FMT=Delimited"""
the weir part now is:
but some data can not be read...even if this data is written (existing) in the csv file....it seems like it's null...it can't be read
can you give me any hints?
this is done via vba
I export info in a .csv file
and then read the .csv file with
objConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & strPathToTextfile & ";" & _
"Extended Properties=""text;HDR=YES;FMT=Delimited"""
the weir part now is:
but some data can not be read...even if this data is written (existing) in the csv file....it seems like it's null...it can't be read
can you give me any hints?