donhannam
asked on
importing a txt / csv file - not picking up the first line - no header line in file
I am using the following code to import a text file which works great except that the first line does not import.
I am sure the reason is the first line is treated as a header and am sure there is a way to import without header such as HDR=No by cannot find any help on correct way to do this - appreciate any ideas:-
Set Importcon = New ADODB.Connection
Importcon.Open "Driver={Microsoft Text Driver (*.txt; *.csv)}; DataSource=" & strFilePath
Set rst = New ADODB.Recordset
strImportSQL = "SELECT * FROM " & strFileName
rst.Open strImportSQL , Importcon
....
I am sure the reason is the first line is treated as a header and am sure there is a way to import without header such as HDR=No by cannot find any help on correct way to do this - appreciate any ideas:-
Set Importcon = New ADODB.Connection
Importcon.Open "Driver={Microsoft Text Driver (*.txt; *.csv)}; DataSource=" & strFilePath
Set rst = New ADODB.Recordset
strImportSQL = "SELECT * FROM " & strFileName
rst.Open strImportSQL , Importcon
....
I general use the transfertext command and import to a temp table. You can then dictate whether there is a header row (delimiters etc)
Have a look at this
http://www.connectionstrings.com/?carrier=textfile
http://www.connectionstrings.com/?carrier=textfile
ASKER
Thanks.
Have used transfer text in past and need to set specification which I have had trouble with.
Connection strings site looks promising - did not see a way to get first line in on the first entry and could not get other methods of connection to work - I am importing in adp access database to MSSQL.
Appreciate any help with full method of connection
Have used transfer text in past and need to set specification which I have had trouble with.
Connection strings site looks promising - did not see a way to get first line in on the first entry and could not get other methods of connection to work - I am importing in adp access database to MSSQL.
Appreciate any help with full method of connection
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
If it still doesn't work, it may be that the PC doesn't have the correct mdac. My *guess* is that dao36.dll needs to be installed since the method uses jet. otherwise trying installing the latest mdac components e.g.
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&displaylang=en
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&displaylang=en
ASKER
Thanks
Thats what I was after - works perfect
Thats what I was after - works perfect