Excel File
Moderators: chulett, rschirm, roy
Excel File
I was trying to insert data into excel file using ODBC stage, somehow i'm getting the following error..
SQLSTATE=S1000, DBMS.CODE=-3035
[DataStage][SQL Client][ODBC][Microsoft][ODBC Excel Driver] Operation must use an updateable query.
My SQL is INSERT INTO "Sheet1$"(COL1, COL2) VALUES (?,?);
Does anybody inserted data into excel file through ODBC,please advise.
SQLSTATE=S1000, DBMS.CODE=-3035
[DataStage][SQL Client][ODBC][Microsoft][ODBC Excel Driver] Operation must use an updateable query.
My SQL is INSERT INTO "Sheet1$"(COL1, COL2) VALUES (?,?);
Does anybody inserted data into excel file through ODBC,please advise.
Re: Excel File
You can use sequential stage and create the file as .csv. This will create a EXCEL spread sheet.
This should work with ODBC - What does the SQL command look like if you use auto-generated commands?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Re: Excel File
fyi.. xls format is not same as .csvnivas wrote:You can use sequential stage and create the file as .csv. This will create a EXCEL spread sheet.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Nivas - a .csv file is not the same as a .xls file; the OP is using ODBC to populate the Excel sheet directly.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Can you read from it using COL1 and COL2 in a test job?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
So if you can read from the Excel ODBC then the connection and sheet format is correct. Is your write SQL automatically generated or user-defined?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Does "UPDATE" work?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 224
- Joined: Tue Sep 24, 2002 7:32 am
- Location: Denver, CO USA
You might want to look into the following article at Microsoft:
http://support.microsoft.com/kb/175168
John
http://support.microsoft.com/kb/175168
John