bline22
10-27-2009, 08:19 AM
Hello,
I am trying to read in a CSV file into excel. The issue I am having is, when I read it in it reads all rows, but one of the columns it reads in some of the values and others not. It seems the values that have a character preceeding them don't get read in. Here is my code:
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strFilePath & ";Extended Properties=""text;HDR=No;FMT=Delimited"""
Set oRS = CreateObject("ADODB.RECORDSET")
oRS.Open "SELECT * FROM " & strFileName, oConn, 3, 3
Example data. The first 2 sets as well as the last would get read but the middle 2 show up as blank. any idea why?
416370
416418
82281653L
21033913405
1165899
Thanks for the help.
I am trying to read in a CSV file into excel. The issue I am having is, when I read it in it reads all rows, but one of the columns it reads in some of the values and others not. It seems the values that have a character preceeding them don't get read in. Here is my code:
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strFilePath & ";Extended Properties=""text;HDR=No;FMT=Delimited"""
Set oRS = CreateObject("ADODB.RECORDSET")
oRS.Open "SELECT * FROM " & strFileName, oConn, 3, 3
Example data. The first 2 sets as well as the last would get read but the middle 2 show up as blank. any idea why?
416370
416418
82281653L
21033913405
1165899
Thanks for the help.