Post reply

If i use .Csv file in open Rowset. i am getting Error

  • February 22, 2012 at 7:12 am

    #256208

    When i use .Csv file then i get Error , if i use .xls then i do not get error

    insert into OPENROWSET( 'Microsoft.Jet.OLEDB.4.0', 'Data Source=E:\Book1.csv;Extended Properties=EXCEL 12.0;HDR=YES', 'SELECT InvcNbr,Vendid ,DocDate,OrigDocAmt,RefNbr,Date FROM [Book1$]')

    Error:

    Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".

  • February 22, 2012 at 8:11 am

    #1450326

    Is the Poll added by mistake?

    What code are you using for the .csv and what code are you using for the Excel spreadsheet?

    What you posted isn't too clear because it looks like it's Excel code, but then it's getting the error you said is for a .csv file.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply