Open Tab delimited file with ADO

From: Max Odendahl (max.odendahl_at_t-online.de)
Date: 03/22/04

  • Next message: Debbie Erickson: "Problem saving detail in mstr/dtl application." 
    Date: 22 Mar 2004 09:47:41 -0800

    Hello,

    did anyone manage to opne a tab delimited file with ado?

    I managed to open it now, with this connectionstring:

    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Dokumente und
    Einstellungen\Administrator\Desktop\;Extended
    Properties="text;hdr=no;fmt=tabdelimited;separator=Chr(9);";Persist
    Security Info=False

    And a Schema.ini:

    [hallo.csv]
    Format=TabDelimited
    ColNameHeader=True

    It recognizes the correct columm number, but all fields are empty.

    Any ideas?

    Kindr egards
    max Odendahl

  • Next message: Debbie Erickson: "Problem saving detail in mstr/dtl application."

    Relevant Pages

    • Re: MS Access via ADO from a local HTML page within WebBrowser under XP SP2
      ... Microsoft MVP [Windows] ... | My code hosts the WebBrowser control using the ATL's CAxDialogImpl. ... | database via ADO. ... | to be able to override the security lockdown in a hosted instance of the ...
      (microsoft.public.windowsxp.security_admin)
    • MS Access via ADO from a local HTML page within WebBrowser under XP SP2
      ... Abstract: I cannot get past an ADO error: "Safety settings on this computer ... My code hosts the WebBrowser control using the ATL's CAxDialogImpl. ... This rather brutal approach to knocking holes in security resulted in total ... It appears to me that in this case the prohibition of cross-domain access ...
      (microsoft.public.windowsxp.security_admin)
    • Re: ConnectionString für Access-DB mit MSDataShape
      ... ADO schluckt nicht ... > es (wie ja auch von Peter Fleischer in seiner Antwort auf mein OP ... Er hat Dir empfohlen das aus dem Connectionstring herauszunehmen. ... Genauso kannst Du mit Deinem Recordset verfahren. ...
      (microsoft.public.de.vb.datenbank)
    • Re: Problem mit Datenbankzugriff (VB6)
      ... Connectionstring ist auch in Ordnung. ... Weiterhin kann es auch ein Problem mit der MDAC-Installation des Systems ... Ich greife mittels ADO auf eine SQL-Server Datenbank zu, ... Im Programm hab ich die "Microsoft ActiveX Data Objects 2.7" eingebunden, ...
      (microsoft.public.de.vb.datenbank)
    • Re: Anybody from Access development team or from MS can help me?
      ... Here is a direct quote from Section 45 of the Security FAQ: ... Although ADOX is supposed ... This slapped onto my face> when I found there is no option to specify username and system database ...
      (microsoft.public.access.tablesdbdesign)