Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO and text file
Trying to open a text file using ADO, but don't want it
delimited(comma). When using the following code, it automatically returns comma delimited recordset. If I change the FMT=Delimited to FMT=Fixed, then the RecordSet.Open fails. I've also tried opening with text driver (see below) and get same comma-delimited recordset. Not much ADO experience, so I'm mostly cutting and pasting these coneection strings. Thanks. 'Open an ADO connection to the folder specified Set oConn = CreateObject("ADODB.CONNECTION") oConn.Open _ "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & strFilePath & ";" & _ "Extended Properties=""text;HDR=No;FMT=Delimited""" 'Get the recordset Set oRS = CreateObject("ADODB.RECORDSET") 'Now actually open the text file and import into Excel oRS.Open "SELECT * FROM " & strFilename, oConn, adOpenStatic, adLockReadOnly, adCmdText TEXT DRIVER OPEN "Driver={Microsoft Text Driver (*.txt; *.csv)};" & _ "Dbq=" & strFilePath & ";" & _ "Extensions=txt" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I import text file of cash flow to excel file then use formula | Excel Discussion (Misc queries) | |||
How to tell number of spaces between values in saved text file fromthe original xls file | Excel Discussion (Misc queries) | |||
How do I convert excel file into ASCII text file with alignment? | Excel Discussion (Misc queries) | |||
Open delimited text file to excel without changing data in that file | Excel Programming | |||
Get External Data, Import Text File, File name problem | Excel Programming |