related sites: <FREE Help> <ASP> <Asp.net> <worldwide> feedback: <lovethat> <hatethat> <thanks> <credits> <contact us>
Connection Transaction Problems <Next>
From: Puryear Christian <Christian.Puryear@Columbia.net> Subject: [asp advanced] Comma Delimited help!?! Date: Thu, 30 Apr 1998 13:56:37 -0500
I need to pull the entire text out of a .csv file and am doing so with:
------------------------------------- Set OBJdbConnection = Server.CreateObject("ADODB.Connection") OBJdbConnection.Open "PharmCSV" SQLquery = "SELECT * FROM PACT_MSACCESS.csv" Set rs = OBJdbConnection.Execute(SQLquery) --------------------------------------
but the problem is that I never get the first row of data. I'm guessing that ODBC expects the first row to be the column headings, but in my case, its not. How can I pull back a record set that will take the first line of the .csv file as the first row of data? Is it a different cursor type maybe?
Thanks in advance Christian Puryear
From: Puryear Christian <Christian.Puryear@Columbia.net> Subject: RE: [asp advanced] Comma Delimited help!?! Date: Thu, 30 Apr 1998 15:42:14 -0500
Got it... Had to built a schema.ini
Learn something new everyday........