text file using OLE DB

Results 1 to 2 of 2

Thread: text file using OLE DB

  1. #1
    kavitha Guest

    Default text file using OLE DB

    hi!<BR><BR>Is it possible to retrieve a text file using OLE DB provider...<BR>If so.. how is it? what is the syntax..<BR><BR>Thanx in advance<BR>kavitha

  2. #2
    Join Date
    Dec 1969

    Default Might be a good one for an faq

    Yes, but I&#039ve only gotten it to work with .csv files (and the directory is considered the database)...<BR><BR>Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DSN=Text;DBQ=E:msdbs;DefaultDir=E:msdb s;DriverId=27;FIL=text;MaxBufferSize=2048;PageTime out=5;"<BR><BR>SELECT `junk#csv`.* FROM `junk#csv`<BR><BR>This also works for Excel files, though the syntax is quite a bit different.<BR><BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts